Number of rows used

  • Thread starter Thread starter Bryan Dickerson
  • Start date Start date
B

Bryan Dickerson

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
 
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)
 
That works. Thanx!

Bernie Deitrick said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rows with cells of varying number of lines 5
How to Disable/Enable hide entire row ability 17
Way to make range the whole spreadsheet 3
Excel VB to capture the current cells row number 4
convert columns to rows 6
Excel spreadsheet to Word document 1
Formula to fill in fields when cell is blank 2
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6

Back
Top