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

Thanks. I'll look it up.


"Myrna Larson" wrote:

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