Thread: macro takes 30+ seconds to do an autofit on only 1 out of the 3 sheets it is autofitting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
drdavidge[_11_] drdavidge[_11_] 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

think i found it...

Range("A1", ActiveCell.SpecialCells(xlLastCell)).Select

looks like it working a lot faster now... thanks for your help

--
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