Benefits of using Excel VBA Arrays

Excel VBA Arrays are like super-powered variables. They are a powerful tool you need to learn if you're going to create more effective programs - especially when you work with lots of data.

In this 12 minute introductory video we cover 2 key benefits of Excel VBA Arrays:

• Super-Powered Variables - Instead of separately declaring 100 unique variables, you can declare one array with 100 elements. This saves you from typing out 100 declaration lines!
• Increased program speed - Arrays speed up the process of reading, processing and writing data to a worksheet. You can see 15x speed increases (or more!)

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]