Static Arrays

A static array has a fixed size or number of elements. You specify the array size when you declare it, and the size cannot change during program execution.  The size will be one more than n because VBA array indexes start by default at 0.

You can use an integer variable or constant as the index.

Option Base 1 statement at the start of a module, outside of any procedures. This results in all arrays in the module having a lower bound of 1 instead of 0.

The other choice provides more flexibility, using the To keyword in the array declaration