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
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
  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. 1 trackbacks
    1. 2008/10/24 - VBA: Remove Blank Rows