Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reset Used Range property of worksheet
Excel 2003 SP3
Winows XP Pro SP2 I wrote some [bad] code that was "hiding" a value in cell A65536. When I realized this was causing tiny slider bars and also causing unusually large file sizes, I removed the code. I also selected all the unused rows (from about row 300) and deleted them, then saved. This still didn't fix the tiny slider bar or file size problem - but it should have, no? Is there a way to reset the Used Range property of a worksheet? Could something else be at play here? Any and all help appreciated. Thanks! -gk- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reset the range of FOR loop | Excel Discussion (Misc queries) | |||
Range Validation property not working w/ Protected worksheet | Excel Programming | |||
x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
Range variable not being reset | Excel Programming | |||
Loop thru files in DIR, delete worksheets & reset worksheet Name property?? | Excel Programming |