Add these lines to you code:

Sub Foo()

Application.ScreenUpdating = False

your code here

Application.ScreenUpdating = True

End Sub

--
Biff
Microsoft Excel MVP


"Corinne" wrote in message
...
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?