A dynamic array is declared using the Dim and the ReDim statements.
First, you use the Dim statement to declare the dynamic array by using empty parenthesis.
Then, at a later point in your program, you use the ReDim statement to declare the number
of elements. In fact, you can re-declare a dynamic array as many times as you desire.
Arrays can have up to sixty dimensions. If you wish to create a multiple-dimension
array, you need to declare it using the Dim statement. For example, the following
code creates a three dimensional array. The first dimension has 23 elements, the
second dimension has 15 elements and the third dimension has 201 elements.
Therefore, there are a total of 23x15x201 = 69345 elements in this array.
The number of dimensions that you can create is limited by the available memory.
If you exceed the available memory while declaring an array, you will get an error message.