Thread: Stop the "flashing" when I execute an Excel macro?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Stop the "flashing" when I execute an Excel macro?
Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True


If this post helps click Yes
---------------
Jacob Skaria


"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?
Reply With QuoteReply With Quote