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