Speeding up VBA Code using Calculation Mode

One of the most common requests from people writing VBA code in Excel is “how do I speed up my VBA code?”. The Speeding up VBA Code series aims to give you some quick and easy to implement techniques to speed up your code.

In this free beginner level Excel tutorial we use Microsoft Excel 2016 and you will learn:

  1. How to set up various subroutines and functions that will time how long a given piece of code is taking using the “Timer” VBA function;
  2. How to set up your VBA code to grab certain application level variables (and allow us to restore them);
  3. How to switch your calculation mode from automatic calculation to manual calculation;
  4. How to switch your code so it does not calculate before save;

Once we do all of the above we then demonstrate some performance improvements from running an example recorded macro (not the best example but it will do for now).

The video uses Excel 2016 but the same steps are used for Excel 2010 and Excel 2013.

If you enjoyed this short tutorial then please add a comment, start a discussion, “Like”, “Favourite” or “Share” the tutorial and subscribe to my channel.

Click here for more great videos

Click here for more great videos

Thanks for watching!

Paul.

Leave a Reply

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