View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default 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