Argument limit on user Function?
Look up the TYPE statement in Help.
On Wed, 2 Feb 2005 17:55:07 -0800, "Peter M"
wrote:
Thanks. It's 30, because that's what I'm hitting. The error message isn't
very gooog though; it just says you are trying to pass too many arguments for
the function, instead of you've hit the limit. Anyway, I know about arrays,
but what are user defined types?
"Jim Thomlinson" wrote:
Yup but I do not remember what it is. Something like 40. You can pass
arrays
and user defined types though if you get into trouble.
"Peter M" wrote:
Is there a limit on the number of arguments you can have in a user
defined
Function in Excel?
--
Thanks for any help
|