👉 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