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

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

--
Regards,

Juan Pablo González

"Jim Chandler" wrote in message
...
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

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 wrote:

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

Yep... thanks for the clarification.

--
Regards,

Juan Pablo González

"Jerry W. Lewis" wrote in message
...
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

Thanks guys

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

--
Regards,

Juan Pablo González

"Jerry W. Lewis" wrote in
message
...
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


.