Thread: Supress screen update while writiing to another sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Supress screen update while writiing to another sheet
hi Scooper

Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = true

See this page for example code
http://www.rondebruin.nl/copy1.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"scooper" wrote in message u...
Hi
I am trying to copy data to Sheet2 from Sheet1 without the user seeing the
screen change.
What code sould I use?
Regards
Scooper




Reply With QuoteReply With Quote