UBound Function

Use the LBound and UBound functions to obtain the dimensions of an array during execution of your procedure. The LBound function returns the lower index of an array. For example, for the array Sample described previously, LBound(Sample) returns 1 and UBound(Sample) returns 10. 

A parameter involved in specifying the cell coordinates in an array is called an index if there is any ambiguity about their nature, indices should be declared as integers. (Special VBA functions such as LBound and UBound, for lower bound and upper bound respectively, always specify integers, and therefore need not be dimensioned as such.)... 

---