What is the maximum amount of arguments that a sub can have?

[bigracefan]

I'm getting a too many arguments error when I enter my arguments. Is there a maximum?

Thanks

Pete

 

[Killa]

what is the error number?


are you supplying more auguments than the sub has?

 

[bigracefan]

No I have a huge table that has over 100 fields. I was setting up the arguments that go into it. I get to a certain point that I get an error telling me that I have too many arguments.

Pete

 

[RonVaught]

From MSDN. . .

Too many arguments

A procedure can have only 60 arguments. This error has the following cause and solution: You specified more than 60 arguments. If you must specify more arguments, define a user-defined type to collect multiple arguments of different types, or use a ParamArray as the final argument and pass multiple values to it. You can also pass multiple arguments by placing them in an array.