Thread: Stop the "flashing" when I execute an Excel macro?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Stop the "flashing" when I execute an Excel macro?
application.screenupdating = false
'your code
application.screenupdating = true
--
HTH...

Jim Thomlinson


"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