View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default how to count rows

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