How to make your Excel VBA code run 1000 times faster

👉 Ready to master VBA? - Check out my full courses: https://courses.excelmacromastery.com/ - Subscribe to the channel here: https://bit.ly/36hpTCY - FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: https://bit.ly/2MXsnz9 (Note: If the download page doesn't work then make sure to turn off any popup blockers) In this video I am going to take an Excel Macro and make it run 1000x faster. The code I'm using is a standard code you will see in the real-world. This code reads through 100,000 records and copies the rows which meet given criteria. Starting with very basic VBA code I will keep improving the code until it runs 1000+ times faster than the original. If you are creating Excel VBA code for real-world applications then you should take advantage of these proven techniques. Excel VBA Copy - The Complete Guide to Copying Data: (https://excelmacromastery.com/excel-vba-copy/) Shortcut Keys: Alt + F11: Switch between Excel and the VBA Editor. Ctrl + R: View the Project Properties Window. Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet. F5: Run the code from the current sub. F9(or click left margin): Add a breakpoint to pause the code. Tab: To move lines of code to the right(Indent) Shift + Tab: To move lines of code to the left(Outdent). Table of Contents: 00:00 - Slide 1