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

  • Thread starter Thread starter Corinne
  • Start date Start date
C

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?
 
Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True


If this post helps click Yes
 
Add these lines to you code:

Sub Foo()

Application.ScreenUpdating = False

your code here

Application.ScreenUpdating = True

End Sub
 
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
 
Back
Top