10 Years of VBA Array Knowledge in 40 Mins

👉 Ready to Master VBA?
- Check out my course: https://bit.ly/3XTnIm8
- Subscribe to the channel here: https://bit.ly/36hpTCY
- Want to download the source code for this video? Go here: https://shorturl.at/nMnc6
(Note: If the download page doesn't work then make sure to turn off any popup blockers)


"10 Years of VBA Array Knowledge in 40 Mins"

Arrays are possibly the most important element of Excel VBA.
Not only do arrays make your code more readable, they also allow you to process data thousands of times faster than using Ranges.   If you haven't used arrays before then you may be intimidated by them.   But don't worry - In this video, I will distil years of VBA knowledge and experience into a set of simple steps that anyone can follow.

💻🔧 #VBAArray #VBAArrays #ExcelVBAArrays

Useful VBA Shortcut Keys
========================

Debugging:
Compile the code: Alt + D + L OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9 or click left margin

Windows:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
View the Properties Window: F4
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R

Writing Code:
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Autocomplete word: Ctrl + Space
Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + *
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y (note: this clears the clipboard)


Table of Contents:

00:00 - Introduction
00:22 - Why You Need Arrays
10:17 - How to Replace Ranges with Arrays
21:19 - Using Arrays in a real-world example
27:18 - Important - Avoid this major pitfall
31:59 - The code structure for all data manipulation
40:04 - How to easily sort any Array with this new method