Speeding up VBA Code: Calculation Mode

*********************************
*********************************

Speeding up VBA Code: Calculation mode

Video description
----------------------------
The goal of my Excel VBA tutorials are to take you from a beginner level to a confident Excel VBA developer and programmer as quickly as possible. The best way to do this is to help you UNDERSTAND Excel VBA code and how to build robust Excel spreadsheets.

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.

Channel Links and Playlists
----------------------------

Other Useful Links
----------------------------
You can often find deals on my current and upcoming Udemy courses here

Thanks for watching!

Paul.