Thread: screen updating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SeanEvans[_2_] SeanEvans[_2_] is offline
external usenet poster
  
Posts: 1
Default screen updating

To turn screen updating off -

Application.ScreenUpdating = False

and to turn it back on -

Application.ScreenUpdating = True.

Enjoy

--
SeanEvan
-----------------------------------------------------------------------
SeanEvans's Profile: http://www.excelforum.com/member.php...fo&userid=1465
View this thread: http://www.excelforum.com/showthread.php?threadid=26458

Reply With QuoteReply With Quote