how to count rows

[Reen]

How do you get a total count of the rows you use in your spreadsheet?

 

[John C]

Whichever column you have significant amounts of data in (i.e.: this column,
if anything is in the row, will always be populated).
=COUNTA(A:A)

 

[jlclyde]

How do you get a total count of the rows you use in your spreadsheet?

Or you coudl do it with VBA

Sub LastRow ()
Dim LstRow As Long
LstRow = Range("A65536").end(xlup).row
'Substitute in whatever column you are concerned with for A
End Sub
Jay