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 …

excel vba – simple loop

There are a number of ways of writing loops but I like the Do Until method. The basic structure is as follows: Do Until ‘whatever criteria you set, see below’ ‘code for the action you want’ Loop The code will …