Passing an Indefinite Number of Arguments Using the ParamArray Keyword

PASSING AN INDEFINITE NUMBER OF ARGUMENTS USING THE PARAMARRAY KEYWORD 

Occasionally a Function procedure needs to accept an indefinite number 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 functions list of arguments. The argument declared by the ParamArray keyword is an array of Variant elements. Empty parentheses are required. 

Interestingly, even if you use the Option Base 1 statement, the lower 

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

---