ParamArray keyword

PASSING AN INDEFINITE NUMBER OF ARGUMENTS USING THE PARAMARRAY KEYWORD... 

Occasionally a Function procedure needs to accept an indefinite niunber of arguments. The SUM worksheet function is an example of such a function its syntax is =SUM(number1, number2,...). To allow a Function procedure to accept an indefinite number of arguments, use the ParamArray keyword in the argument list of the function, as in the following expression... 

Only one argument can follow the ParamArray keyword, and it must be the last one in the function s list of arguments. The argument declared by the ParamArray keyword is an array of Variant elements. Empty parentheses are required. 

Elements in the array of arguments passed using the ParamArray keyword can themselves be arrays. 

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

MakeArray.xls is a Function procedure that combines individual worksheet ranges into an array. This Function procedure illustrates the use of the ParamArray keyword. 

---

See also in sourсe #XX -- [ , ]

---