Screen flashing During Macro

[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.

 

[Dave Peterson]

application.screenupdating = false
'your code here
application.screenupdating = true

 

[Gord Dibben]

Michael

Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True

Gord Dibben Excel MVP

 

[Guest]

Thanks Dave
Your info is much appreciated

Regards
Michael.

application.screenupdating = false
'your code here
application.screenupdating = true