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, 2012, 2013
For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes
-- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --
as you can tell, I'm still learning !!!