Thread: macro takes 30+ seconds to do an autofit on only 1 out of the 3 sheets it is autofitting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
drdavidge[_6_] drdavidge[_6_] is offline
external usenet poster
  
Posts: 1
Default macro takes 30+ seconds to do an autofit on only 1 out of the 3 sheets it is autofitting

Peter T Wrote:
You've probably got a very large Usedrange, try Ctrl-End.

Regards,
Peter T



With Ctrl-End, it goes from A1 to BR568 - which is the same as th
first sheet. That is all the data (kind of a lot). Any other ideas

--
drdavidg
-----------------------------------------------------------------------
drdavidge's Profile: http://www.excelforum.com/member.php...fo&userid=3616
View this thread: http://www.excelforum.com/showthread.php?threadid=56110

Reply With QuoteReply With Quote