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" <PeterM@discussions.microsoft.com> wrote in message
> news:18368078-A4D6-4776-93A7-018DAFA9105D@microsoft.com...
> > 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
>
>
>