Thread: Can I keep the screen from jumping when running a macro?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default Can I keep the screen from jumping when running a macro?
Try this:
Application.ScreenUpdating = False
your code
Application.ScreenUpdating = true

Reply With QuoteReply With Quote