Stop the "flashing" when I execute an Excel macro?

[Corinne]

When I run an Excel macro containing a lot of Copy and Paste functions, the
worksheets it is copying and pasting from flash on the screen. Is there a
way I can stop this from occurring?

 

[Jacob Skaria]

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


If this post helps click Yes

 

[Jim Thomlinson]

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

 

[T. Valko]

Add these lines to you code:

Sub Foo()

Application.ScreenUpdating = False

your code here

Application.ScreenUpdating = True

End Sub

 

[Gord Dibben]

The "flashing" usually comes from "selecting" things.

Your code can usually be edited to remove all those "selects" to stop the
jumping around and make your code run faster.

Post your code or go with the screenupdating method others posted.


Gord Dibben MS Excel MVP