VBA Course: https://www.teachexcel.com/vba-course-update.php
Excel File: https://www.teachexcel.com/excel-tutorial/2405/3-tips-for-faster-and-better-vba-macros-in-excel-simple-to-advanced?nav=yt
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/vba-course-update.php
- Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_b04lEbisWyQ
TeachExcel.com
#msexcel #howto #tutorial