Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Real Value of .UsedRange.Rows.Count
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 correct last row after an update that changes the number of used rows in my worksheet. The problem is that my worksheet contains 80 rows of real data. However 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 on cells that now have a value in them? -- dazman ------------------------------------------------------------------------ dazman's Profile: http://www.excelforum.com/member.php...o&userid=25903 View this thread: http://www.excelforum.com/showthread...hreadid=398856 |
#2
|
|||
|
|||
There is some code here to reset the usedrange.
http://www.contextures.on.ca/xlfaqApp.html#Unused Hope this helps Rowan "dazman" wrote: 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 correct last row after an update that changes the number of used rows in my worksheet. The problem is that my worksheet contains 80 rows of real data. However 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 on cells that now have a value in them? -- dazman ------------------------------------------------------------------------ dazman's Profile: http://www.excelforum.com/member.php...o&userid=25903 View this thread: http://www.excelforum.com/showthread...hreadid=398856 |
#3
|
|||
|
|||
Very useful info -- dazman ------------------------------------------------------------------------ dazman's Profile: http://www.excelforum.com/member.php...o&userid=25903 View this thread: http://www.excelforum.com/showthread...hreadid=398856 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
real estate sales template? | Charts and Charting in Excel | |||
real estate calculations | Excel Discussion (Misc queries) | |||
Can I have spell check ignore errors and alert me to real words? | Excel Discussion (Misc queries) | |||
how to include real time & date on a worksheet | Excel Discussion (Misc queries) |