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
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