This is a discussion on Find number of rows in worksheet within the Excel Questions forums, part of the Question Forums category; Hello, Please could you tell me how to find the number of rows (empty or filled) in a worksheet? (I ...
Please could you tell me how to find the number of rows (empty or filled) in a worksheet?
(I need my macro to work in different excel versions so can't assume the usual ~65000 rows)
Dim LASTROW As String
LASTROW = Range("A65536").End(xlUp).Row
That usually works for me when I know that Col A will contain info in the last row.
Excel MVP 2011-2014
as you can tell, I'm still learning !!!