The complete guide to using arrays in Excel VBA

This post provides an in-depth look at arrays in the Excel VBA programming language. It covers the important points such as:

• Why you need arrays.
• When should you use them.
• The two types of arrays.
• Using more than one dimension.
• Declaring arrays.
• Adding values.
• Viewing all the items.
• A super efficient way to read a Range to an array.