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 …