UBound

UBound Returns the upper limit of an array dimension. 

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. 

The complete syntax of LBound and UBound is LBound(arrayname, dimension). For the array Spectrum dimensioned thus ... 

Since FINEST requires that there be the same number of values for each independent variable, we first check to make sure that each range in the array of arguments has the same number of rows. An interesting point although we specified Option Base 1, the ParamArray keyword produces an array whose lower array index is zero. Thus we must loop from 0 to UBound(rng). Note that UBound(rng) is the number of elements in the array, while... 

Example If the array table was dimensioned using the statement Dim table (1 To 3, 1000), UBound(table,3) returns 1, UBound(table,2) returns 1000. 

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.)... 

If UBound(Field 1) > 2 And UBound(Field 2) > 2 Then Numlnt CVErr(xlErrValue)... 

---