VBA: Turn off Screen Updating

August 14th, 2004 | Categories: VBA | Tags: , ,

As cool as it looks watching your macro manipulate the screen, you can help it run faster if you turn off Screen Updating.

1. At the beginning of your code put this line:

Application.ScreenUpdating = False

2. At the end of your code put this line:

Application.ScreenUpdating = True

Get LIVE Help
Custom Excel solutions & live Excel help!
► Go to www.ExcelAutomationHelp.com
► Email Now@ExcelAutomationHelp.com
  1. July 29th, 2010 at 10:25
    Reply | Quote | #1

    Hey, thanks for easy & simple explanation. I had a problem with data import and graph updating after every single record…

  2. December 5th, 2010 at 22:04
    Reply | Quote | #2

    Very well written article, thx for sharing.

  3. PD2JK
    December 17th, 2013 at 14:24
    Reply | Quote | #3

    Thanks! Great solution, especially when using a recorded macro in combination with RDP/Terminal Server/Citrix on a slow connection!

  4. 1 trackbacks
    1. 2008/10/24 - VBA: Remove Blank Rows