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

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)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Reen" wrote:

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

On Oct 31, 9:16*am, Reen (donotspam) wrote:
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

On Oct 31, 2:16*pm, Reen (donotspam) wrote:
How do you get a total count of the rows you use in your spreadsheet?

With the Status bar displayed (from the View menu), right click in the
status area (to the right of the bar) and select count.
Now simply highlight a column and the count figure will tell you how
many rows have values.

This actually counts the number of non-empty cells so it has a number
of uses.