Turning off screen update while macro runs

  • Thread starter Thread starter dancingflames
  • Start date Start date
D

dancingflames

Hi,

I was wondering if there was a way to turn off the screen update while
a macro runs, and then to turn it on again once it is complete. Also,
does this help the throughut time at all?

Thanks for the help.
 
dancingflames,

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


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"dancingflames" <[email protected]>
wrote in message
news:[email protected]...
 
Back
Top