Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Articles Figures Tables About

Passing an Indefinite Number of Arguments Using the ParamArray Keyword

PASSING AN INDEFINITE NUMBER OF ARGUMENTS USING THE PARAMARRAY KEYWORD [Pg.289]

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 [Pg.289]

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. [Pg.289]

Interestingly, even if you use the Option Base 1 statement, the lower [Pg.289]

Elements in the array of arguments passed using the ParamArray keyword can themselves be arrays. [Pg.289]




SEARCH



Argument

Indefinite number of arguments

Keyword

Keywords

Number of passes

ParamArray keyword

Passes, number

Passing

The Argument

© 2024 chempedia.info