*********************************
Get my VBA Troubleshooter course for only $10 [ Ссылка ]
*********************************

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
----------------------------
[ Ссылка ]
Understanding VBA Code playlist: [ Ссылка ]
Official Channel Series: [ Ссылка ]

Other Useful Links
----------------------------
My facebook Page can be found here: [ Ссылка ]
My Blog sometimes has VBA/Excel related content: [ Ссылка ]
A full list of my Udemy courses can be found on my Udemy profile page: [ Ссылка ]
My Excel VBA Troubleshooter course is here: [ Ссылка ]
You can often find deals on my current and upcoming Udemy courses here
[ Ссылка ]

WiseOwl provides a lot of very good VBA tutorials: [ Ссылка ]
Sali Kaceli provides a lot of Excel and VBA related tutorials also: [ Ссылка ]
Chip Pearson has a lot of VBA content - if Chip says you should do something ... you probably should: [ Ссылка ]


Thanks for watching!

Paul.

свернуть