Find number of rows in worksheet

[poiu]

Hello,

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)

Thanks,

Poiu

 

[Firefly2012]

Hi

Try:

MsgBox Sheets("SheetNameHere").Rows.Count

 

[salfordchameleon]

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.

 

[wigi]

Dim LASTROW As String
LASTROW = Range("A65536").End(xlUp).Row

Dim LASTROW As Long

 

[salfordchameleon]

cheers wigi

as you can tell, I'm still learning !!!