Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.UsedRange.Rows.Count = 5002? why?
hi there
my code ActiveSheet.UsedRange.Rows.Count gives 5002, but i am only using 1 (cannot set to one as in future this will be dynamic...) any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.UsedRange.Rows.Count = 5002? why?
go down to row 5002 and select the entire row and then hit delete.
now try the code again J Buffyslay wrote: hi there my code ActiveSheet.UsedRange.Rows.Count gives 5002, but i am only using 1 (cannot set to one as in future this will be dynamic...) any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.UsedRange.Rows.Count = 5002? why?
WhytheQ wrote: go down to row 5002 and select the entire row and then hit delete. now try the code again J Buffyslay wrote: hi there my code ActiveSheet.UsedRange.Rows.Count gives 5002, but i am only using 1 (cannot set to one as in future this will be dynamic...) any ideas? you've probably got blank rows = no value, but excel still counts them (cause there has been some operation made on this row in the past) go to: http://www.contextures.com/xlfaqApp.html#Unused |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting ActiveSheet.UsedRange | Excel Programming | |||
Problem with USEDRANGE.ROWS.COUNT reporting one row too many | Excel Programming | |||
how to reset the activesheet usedrange value | Excel Programming | |||
Real Value of .UsedRange.Rows.Count | Excel Worksheet Functions | |||
Problem with UsedRange.Rows.Count | Excel Programming |