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.

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

Leave a Reply

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