excel vba – screen updating

This can speed up long macros, by running in the background without the need to show on screen.

The line of code below should be put at the start of your macro.
Application.ScreenUpdating=FALSE

This is an Excel wide setting so you must remember to turn it on again before your Macro ends by adding.
Application.ScreenUpdating=TRUE

Leave a Reply

Your email address will not be published. Required fields are marked *