How do you get a total count of the rows you use in your spreadsheet?
J John C Oct 31, 2008 #2 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)
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)
J jlclyde Oct 31, 2008 #3 How do you get a total count of the rows you use in your spreadsheet? Click to expand... 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
How do you get a total count of the rows you use in your spreadsheet? Click to expand... 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
