Screen flashing During Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All
I have a really long Macro that executes over a number of pages.
When the Macro is run all of the page changes happen (obviously) in the
background.
I vaguely remember a command that could stop all this happening so that
there was no flashing and page changing, just carry out the function and show
the result. Can someone please advise how to do this.
 
application.screenupdating = false
'your code here
application.screenupdating = true
 
Michael

Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True

Gord Dibben Excel MVP
 
Thanks Dave
Your info is much appreciated

Regards
Michael.

Dave Peterson said:
application.screenupdating = false
'your code here
application.screenupdating = true
Click to expand...
 
Back
Top