How to count the number of rows in excel with data?

by

I like this way:

ActiveSheet.UsedRange.Rows.Count

The same can be done with columns count. For me, always work. But, if you have data in another column, the code above will consider them too, because the code is looking for all cell range in the sheet.

More Related Contents:

  1. Clean up Excel Interop Objects with IDisposable
  2. The proper way to dispose Excel com object using VB.NET?
  3. VB.Net – Excel COM Object not getting released [duplicate]
  4. VB.NET Excel Program Leaves EXCEL.EXE floating after completion
  5. How to loop through all the properties of a class?
  6. Case insensitive string compare in LINQ-to-SQL
  7. Does XSLT have a Split() function?
  8. Fastest method to remove Empty rows and Columns From Excel Files using Interop
  9. Pick unique Random numbers
  10. Which is generally best to use — StringComparison.OrdinalIgnoreCase or StringComparison.InvariantCultureIgnoreCase?
  11. Calling a .net library method from vba
  12. System.Runtime.InteropServices.COMException (0x800A03EC)
  13. How do I validate email address formatting with the .NET Framework?
  14. Does this code prevent SQL injection?
  15. Option Strict On and .NET for VB6 programmers
  16. RestSharp serialization to JSON, object is not using SerializeAs attribute as expected
  17. Windows 7 .net Excel .SaveAs() Error Exception from HRESULT: 0x800A03EC
  18. Translate a column index into an Excel Column Name
  19. How to print datagridview table with its header in vb.net?
  20. How to draw a signature and save it to disc as a Bitmap?
  21. How to convert date format in vb.net?
  22. LinqToSql declare and instantiate DataContext best practice?
  23. Assigning a value to ComboBox Items
  24. Are nested Try/Catch blocks a bad idea?
  25. Shadows vs Overloads in VB.NET
  26. Custom button captions in .NET messagebox?
  27. .NET — Textbox control – wait till user is done typing
  28. How to post a file via HTTP post in vb.net
  29. How to securely store a connection string in a WinForms application?
  30. Visual Basic Capture output of cmd

Leave a Comment