The ReDim statement is used to size or resize a dynamic array that has already been formally declared by using a Private, Public, or Dim statement with empty parentheses (without dimension subscripts). You can use the ReDim statement repeatedly to change the number of elements and dimensions in an array.
What are different types of arrays?
There are three different kinds of arrays: indexed arrays, multidimensional arrays, and associative arrays.
How do I initialize an array in VBA?
To initialize an array variable by using an array literal
Either in the New clause, or when you assign the array value, supply the element values inside braces ( {} ). The following example shows several ways to declare, create, and initialize a variable to contain an array that has elements of type Char .