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