Thread: Posible to speed up query update with Apllication.screenupdating?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Lincoln Mark Lincoln is offline
external usenet poster
  
Posts: 227
Default Posible to speed up query update with Apllication.screenupdating?
Setting ScreenUpdating to False simply keeps Excel from showing
everything that's happening while your code is running. Setting it
back to True lets you see what's happening again. If your code doesn't
overwrite rows, ScreenUpdating won't change that.

Reply With QuoteReply With Quote