Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I had previously described a problem where I thought that
EntireColumn.AutoFit was going into a loop. However upon further investigation, I found that given enough time, the AutoFit will eventually finish. Here's the scoop: - I have a worksheet that has a little over 35,500 rows in it. - If I try to AutoFit column C it takes about 1:45 on a very fast (i.e., 3.2ghz) system. - If I delete the first row of worksheet and do the AutoFit it completes in about 1 second. - There is nothing special about the first row. In fact cell C1 has nothing in it. - If I select cells C2:C100 and do the AutoFit (without deleting the first row) it completes in about 4 seconds (4x as long as AutoFitting the whole column once I delete the first row). I've reproduced these results in Excel 97 - Excel 2003. Any suggestions? TIA, josh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofit (Columns.EntireColumn.AutoFit) does not work | Excel Discussion (Misc queries) | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
autofit does not autofit | Excel Discussion (Misc queries) | |||
EntireColumn.AutoFit - Slow on Large Files??? | Excel Programming | |||
row autofit | Excel Programming |