VBA Course: https://www.teachexcel.com/vbacourse...
Excel File: https://www.teachexcel.com/exceltuto...

Make a 3 minute macro execute in less than 1 second!

Learn to make faster, better, and more robust macros with these 3 techniques. And yes, we will be using arrays for the advanced example.

In this Excel VBA tutorial, I walk you through the usage and implementation of these 3 teachniques to teach you how to use them, and not just show you 3 bullet points.

The examples for this tutorial are based on changing values in 30,000 cells and we really will take a macro that performs this task in 3 minutes ( 187 seconds to be precise) and chops that down to less than 1 second ( 0.08 seconds to be precise).

Excel Courses:
VBA/Macro Course: https://www.teachexcel.com/vbacourse...
Building Professional Forms: https://www.teachexcel.com/premiumco...

TeachExcel.com

#msexcel #howto #tutorial