How do I tell how many rows are really used in a spreadsheet?

Bryan,

Count of actually used rows:
MsgBox ActiveSheet.UsedRange.Rows.Count

Highest row number
MsgBox Range("A1").SpecialCells(xlCellTypeLastCell).Row

Usually the same, but not always....

HTH,
Bernie
MS Excel MVP

"Bryan Dickerson" wrote in message
...
How do I tell how many rows are really used in a spreadsheet?

That works. Thanx!

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Bryan,

Count of actually used rows:
MsgBox ActiveSheet.UsedRange.Rows.Count

Highest row number
MsgBox Range("A1").SpecialCells(xlCellTypeLastCell).Row

Usually the same, but not always....

HTH,
Bernie
MS Excel MVP

"Bryan Dickerson" wrote in message
...
How do I tell how many rows are really used in a spreadsheet?

Do you mean the number of rows in the usedrange,

activesheet.usedrange.rows.count

or specifically those rows that contain data?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bryan Dickerson" wrote in message
...
How do I tell how many rows are really used in a spreadsheet?