Is there a limit on the number of arguments you can have in a user defined
Function in Excel?
--
Thanks for any help

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. 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

it just says you are trying to pass too many arguments for
the function, instead of you've hit the limit.

There's a difference there?

Depends on how you look at it. It's true that the current error message,
stictly speaking, does cover hitting the argument number limit. But if you
are not aware of the limit to begin with, as in my case, you waste a lot of
time counting arguments, etc, trying to figure out what's wrong, when a
simple message saying you've hit the limit would have been infinitely more
helpful. Luckily I have enough previous programming experience that it
occured to me that there may be a limit.

"Myrna Larson" wrote:

it just says you are trying to pass too many arguments for
the function, instead of you've hit the limit.

There's a difference there?

That seems unnecessarily trite. If you know you have too many, rather than
try to get to the number one less than the max, you look at a re-design.
Pushing to the boundaries is rarely a good idea.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peter M" wrote in message
...
Depends on how you look at it. It's true that the current error message,
stictly speaking, does cover hitting the argument number limit. But if you
are not aware of the limit to begin with, as in my case, you waste a lot
of
time counting arguments, etc, trying to figure out what's wrong, when a
simple message saying you've hit the limit would have been infinitely more
helpful. Luckily I have enough previous programming experience that it
occured to me that there may be a limit.

"Myrna Larson" wrote:

it just says you are trying to pass too many arguments for
the function, instead of you've hit the limit.

There's a difference there?

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

Peter,
IMO if you are passing 30 arguments, you should look at your design again.
If it really require these 30 different pieces of information to return a
single answer, you may be trying to do too much in one function.
If you are passing 30 cell values to calculate say an average, just pass the
Range concerned.

NickHK

"Peter M" wrote in message
...
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

Nick-

Thanks for your reply. Perhaps so. My programming experience is Fortran
(which obviously dates me), and in Fortran it is not uncommon to have a long
argument list. I would be happy to redesign if I knew how. What I am doing
is passing values in cells, say B11:B39 & B8 into a function I wrote in VB
which performs Newton-Raphson iteration and returns a single value, which is
the result of the iteration. Up to now the number of arguments I passed was
under the limit of 29. I need to be able to pass more than 29 though. How
can I pass these arguments, using the example I give above, pass B11:B39 &
B8. Also, what do I need to do to the function statement (if anything) to
receive arguments passed in an array form.

Thanks,

Peter

"NickHK" wrote:

Peter,
IMO if you are passing 30 arguments, you should look at your design again.
If it really require these 30 different pieces of information to return a
single answer, you may be trying to do too much in one function.
If you are passing 30 cell values to calculate say an average, just pass the
Range concerned.

NickHK

"Peter M" wrote in message
...
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

=myFunction(B11:B39,B8)

is two arguments. You have 27 left.

You have to write your function to work with multiple cells in a single
argument.

--
Regards,
Tom Ogilvy

"Peter M" wrote in message
...
Nick-

Thanks for your reply. Perhaps so. My programming experience is Fortran
(which obviously dates me), and in Fortran it is not uncommon to have a
long
argument list. I would be happy to redesign if I knew how. What I am
doing
is passing values in cells, say B11:B39 & B8 into a function I wrote in VB
which performs Newton-Raphson iteration and returns a single value, which
is
the result of the iteration. Up to now the number of arguments I passed
was
under the limit of 29. I need to be able to pass more than 29 though.
How
can I pass these arguments, using the example I give above, pass B11:B39 &
B8. Also, what do I need to do to the function statement (if anything) to
receive arguments passed in an array form.

Thanks,

Peter

"NickHK" wrote:

Peter,
IMO if you are passing 30 arguments, you should look at your design
again.
If it really require these 30 different pieces of information to return
a
single answer, you may be trying to do too much in one function.
If you are passing 30 cell values to calculate say an average, just pass
the
Range concerned.

NickHK

"Peter M" wrote in message
...
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