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