How to determine the last Row used in VBA including blank spaces in between [duplicate]

by

The best way to get number of last row used is:

ActiveSheet.UsedRange.Rows.Count for the current sheet.

Worksheets("Sheet name").UsedRange.Rows.Count for a specific sheet.

To get number of the last column used:

ActiveSheet.UsedRange.Columns.Count for the current sheet.

Worksheets("Sheet name").UsedRange.Columns.Count for a specific sheet.

I hope this helps.

Abdo

More Related Contents:

  1. VBA comma separated cells, needt last entry only
  2. Wait for shell command to complete [duplicate]
  3. Unique Random Numbers using VBA
  4. Populate unique values into a VBA array from Excel
  5. How to return the number of dimensions of a (Variant) variable passed to it in VBA [duplicate]
  6. How to add a named sheet at the end of all Excel sheets?
  7. Find last used cell in Excel VBA
  8. VBA general way for pulling data out of SAP [closed]
  9. Does Dir() make any guarantee on the order of files returned?
  10. Call a Sub with a String
  11. Delete Row based on Search Key VBA
  12. ShowAllData method of Worksheet class failed
  13. Detect if range is empty
  14. Checking if a worksheet-based checkbox is checked
  15. Assign keyboard shortcut to run procedure
  16. Uncheck all checkboxes across entire workbook via CommandButton
  17. return csv file as recordset
  18. VBA workbooks.Close without being prompted to if the user wants to save?
  19. Get text from clipboard using GetText – avoid error on empty clipboard
  20. Copy a selected range to another worksheet
  21. Benchmarking VBA Code
  22. Excel macro – paste only non empty cells from one sheet to another
  23. The MacScript function is not working well in Office for Mac 2016! Any ideas?
  24. Pointers needed for speeding up nested loop macro in VBA
  25. Display milliseconds in Excel
  26. Application.Quit command not closing the entire Excel Application
  27. Create hyperlink to another sheet
  28. Trying to open the workbook in separate instance
  29. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment