The variable type of vba array subscript can only be a long integer, which is what we call an integer.

This subscript is the maximum value of the indicated array dimension, which is the size of the array.

To determine the size of an array, you can use the ubound () function.