VBA: Turn off Screen Updating

August 14th, 2004 | Categories: VBA | Tags: screen updating, turn off, VBA

-->

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!