Speeding up macros – screen flicker

Stop screen updating

By Neale Blackwood

One technique to speed up macros is to stop the screen from updating as the macro runs. When the screen flickers and shows each step in the macro it is actually slowing down the macro. You can insert the following command at the start of the macro code to stop this screen flicker.

Application.ScreenUpdating = False

You should also turn on the updating by inserting the following command at the end of your code, before the End Sub command.

Application.ScreenUpdating = True

First published: CPA AUSTRALIA Website 2009