Tuesday, 22 June 2010

Speeding up VBA Macros in Excel

I have stumbled upon a good way to speed up macros in Excel. If you use the Application.ScreenUpdating = False argument at the beginning of the macro, then the macro will not display what it is doing. Then when you use the argument Application.ScreenUpdating = True at the end of the macro everything the macro has done will become visible. This works well in speeding up long and complex macros.

No comments:

Post a Comment