UBound(MySpecialArray())' Will give the upper bound (i.e., element number)
LBound(MySpecialArray())' Will give the lower bound
UBound(MySpecialArray(), 2)' Will give the upper bound if a multi-dimensional array (same with the lower).  This last example expects the first number to be the number of dimensions and the 2nd number to be the element number.