ParamArray

J

Jim Chandler

Does anyone know if there is a limit on the number of
arguments that can be used with ParamArray or is there a
limit to the number of arguments that can be used in any
function.

Thanks,
Jim
 
J

Juan Pablo Gonzalez

30 arguments is the maximum (you can see that by using the SUM() function
for example)
 
J

Jerry W. Lewis

Actually, the limit is 29 arguments for user written functions that are
called from Excel. ParamArray will result in the Function Wizard
prompting for a 30th argument, but you will get an error if you try to
enter that 30th argument.

Jerry
 
Top