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)