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

On Thu, 25 Jun 2009 10:37:02 -0700, Corinne
wrote:

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?