What is the max number of argument for a UDF? 1

[steve728]

What is the maximum number of arguments you can insert into a User Defined Function?

Public Function(Arg1 as string, Arg2 as string...

Thanks in advance,

Steve

 

[MajP]

I have never read anything that says that there is a limit (not to say there is not), but if you are going to send in a whole lot of arguments sometimes you may want to use a
PARAMARRAY

http://www.vb-helper.com/howto_param_array.html

Remember it has to be declared as Variant, and must be the last argument in the argument list

Anyways, why do you ask? Have you run into a limit. I have used some pretty large parameter arrays and have not experience a problem.

If you never used PARAMARRAY is can add a lot of flexibility to a function, where you can pass the same function 2 arguments or 20 arguments.

 

[steve728]

Dear MajP,

No I haven't run into any argument limits. I'm creating a utility UDF and wanted to know ahead of time. Thanks again.

Steve