Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit Infinite Loop?
I have an add-in that let's users manipulate potentially large sets of data.
After certain operations, my code will autofit the column widths of a variable number of columns with code like: range("A9:C9").EntireColumn.AutoFit I've never had any problems with this in the past. However one user has created a situation where the above operation never completes (Task Manager shows Excel using 99% of the cpu until we kill the process). The worksheet being AutoFitted has 32,545 rows. So big but not gigantic. I've ensured that there are no merged cells in the range before trying the AutoFit. I've also tried doing the AutoFit one column at a time (e.g., range("A9").EntireColumn.AutoFit) but that loops too on the first column. So far the only two versions of Excel I've been able to test with are Excel 2002 and Excel 2002 SP3. Any good ideas out there? TIA, josh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT- Can't get out of infinite loop | Excel Discussion (Misc queries) | |||
For Next Infinite Loop | Excel Discussion (Misc queries) | |||
Infinite loop? Help. | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Infinite Loop | Excel Programming |