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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Range Arguments 1
Optional argument as Variant not acting like number 4
Calling Error Handling in VBA 1
Use VB array as as argument for worksheet function 9
Passing a simple structure from VB6 to VB.Net Options 1
limit on DLL function arguments 4
Excel User Defined function calling RTD 1

Back
Top