Functions and Maximum # of arguments

[Zebadiah]

I've written a function that has 32 arguments (variables) and when insert the function into the excel cell for calculation, it gives me an undefined error and always highlights a cell reference in the function. Is there a maximum # of arguments that a function in VBA can handle?


Function Test(n1, n2, n3, ....n32)

End Function



in Cell
=Test(a1,a2, a3, ....a32)
gives an error


Any ideas?

 

[Zebadiah]

OK an addition, the maximum number of variables that excel can handle as far as I can tell is 29. After that I get a #Value error.