The VBA array is a very convenient and efficient structure for storing multiple items of usually the same data type. The size of a VBA array can be either fixed or dynamic depending on how it is declared. VBA arrays can also be 1 or multi-dimensional.
This article presents a comprehensive overview of using VBA arrays.
Full article: VBA: The VBA array