limitation on number of arguments for VB func. called from excel?

[Tonia T.]

I am trying to call a VB function from excel. The function initially had 22
arguments, and worked OK. Now it has 23 arguments. Excel seems to have
trouble loading this function. When I try to select it from user defined
functions, the box where I can fill out the arguments does not come up.
The arguments are of different types: long, double and range.

[Ken Dopierala Jr.]

Hi,

I couldn't find any information on a limit of arguements. Maybe try
removing the first argument and see if that fixes it, if not maybe there is
something wrong with the last argument you added. Otherwise try sending in
your longs and doubles as arrays to cut down the number of arguments you are
passing. Good luck! Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Tonia T." <Tonia [e-mail]> wrote in message
news:71**********************************@microsof t.com...

I am trying to call a VB function from excel. The function initially had 22 arguments, and worked OK. Now it has 23 arguments. Excel seems to have
trouble loading this function. When I try to select it from user defined
functions, the box where I can fill out the arguments does not come up.
The arguments are of different types: long, double and range.

[Ken Dopierala Jr.]

Hi,

I did find that for Excel 2000 the maximum number of arguements is 30. Why
it quits at 23 on you I don't know. Good luck! Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Ken Dopierala Jr." <kd*********@wi.rr.com> wrote in message
news:OL**************@TK2MSFTNGP12.phx.gbl...

Hi,

I couldn't find any information on a limit of arguements. Maybe try
removing the first argument and see if that fixes it, if not maybe there is something wrong with the last argument you added. Otherwise try sending in your longs and doubles as arrays to cut down the number of arguments you are passing. Good luck! Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Tonia T." <Tonia [e-mail]> wrote in message
news:71**********************************@microsof t.com...

I am trying to call a VB function from excel. The function initially had

22

arguments, and worked OK. Now it has 23 arguments. Excel seems to have
trouble loading this function. When I try to select it from user defined
functions, the box where I can fill out the arguments does not come up.
The arguments are of different types: long, double and range.