Thread: How stop display of worksheets during macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default How stop display of worksheets during macro
Hi John

Application.ScreenUpdating = False
...
do your stuff
...
Application.ScreenUpdating = True

--
Regards

Roger Govier


"John" wrote in message
...
I have a macro that copies a bunch of data between worksheets. It would
run a
lot faster if I could tell excel to stop displaying worksheets. How do
I turn
this fcn off and back on again?


Reply With QuoteReply With Quote