Real Value of .UsedRange.Rows.Count

  • Thread starter Thread starter dazman
  • Start date Start date
D

dazman

Hi,

In VBA I'm setting a variable as follows:
NumRows = Sheets("Summary").UsedRange.Rows.Count

and NumRows is subsequently used to make sure a chart has the correc
last row after an update that changes the number of used rows in m
worksheet.

The problem is that my worksheet contains 80 rows of real data. Howeve
there once existed 600 rows. Would be grateful if anyone knows how I
can get Excel to forget about what once existed and only concentrate o
cells that now have a value in them
 
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

Insert blanks, but populate new blank rows in one column 6
insert rows--->protected sheet 1
append multiple worksheets data into a single multi-dimensional array 4
Scrabble Value calculation for Welsh words 0
UsedRange.Rows.Count value 5
complex sort search and replace macro 2
Activecell and integers 2
Excel lookup across entire workbook 1

Back
Top