VBA Tip: Lower the Execution Time of a Macro

If you are using a macro that calls for a lots of modifications to your worksheet, Excel will update its display each time the worksheet is modified, which can cause the macro to run considerably slower...

To tell Excel not to update the display, add this to your code:

Sub example()

    Application.ScreenUpdating = False
    'The rest of your code here ...
    Application.ScreenUpdating = True 'Optional
End Sub

Example showing how much time can be saved

The following test was carried out by the macro that generates the annual calendar for the Calendar-Pratique application.

Without ScreenUpdating, the execution time was 27.98 seconds:

before screenupdating

With ScreenUpdating, the execution was reduced to only 0.59 seconds:

after screenupdating

If your macro runs a bit slow, you should think about using this trick!