There are many kinds of arrays in Visual Basic for Applications. Specifically, there are three fundamental attributes of each array, determined at compile time by how the array is declared:
Element data type
Number of dimensions
Fixed or Dynamic Length
Each of these attributes will be discussed in detail in this article. Read more