ParamArray

[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

 

[Juan Pablo Gonzalez]

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

 

[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

 

[Juan Pablo Gonzalez]

Yep... thanks for the clarification.

 

[Jim Chandler]

Thanks guys

Jim

-----Original Message-----
Yep... thanks for the clarification.

--
Regards,

Juan Pablo González




.