3 Tips for Faster and Better VBA Macros in Excel - Simple to Advanced

Add to Favorites
Author: | Edits: don

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).


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)