Скачать или смотреть 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-v...)

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