A dynamic array does not have a fixed size. It can be enlarged or shrunk as needed by code during program execution. A dynamic array is declared by using empty parentheses in the Dim statement.
Before using the array, you must set its size using the ReDim statement.
When you use ReDim, any data in the array is normally lost. You can preserve existing array data (with some limitations) by including the Preserve keyword in the ReDim statement.