View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
prepotency[_2_] prepotency[_2_] is offline
external usenet poster
 
Posts: 1
Default EntireColumn.AutoFit - Slow on Large Files???


It's not a linear function with respect to time: in other words, the
more columns you autofit doesn't necessarily increase the time that the
function takes linearly. The autofit exibits behavior more like a log
function and plateaus with respect to the time it takes.
I often use autofit in my data comparison programs with sheets having
10,000 rows and 20+ columns and it doesn't take any time at all.


garrett (MIS)


--
prepotency
------------------------------------------------------------------------
prepotency's Profile: http://www.excelforum.com/member.php...o&userid=24155
View this thread: http://www.excelforum.com/showthread...hreadid=377820