Argument limit in Excel Function Wizard

A

awaters

I have a VBA function with 24 arguments but it doesn't display properly
in the Excel Function Wizard. However, it works OK if I reduce the
length of some of the argument names. From experimentation it appears
that there is a limit on the total number number of characters used
within argument names. Can anyone confirm this and tell me the exact
limit in Excel 2000 and later versions?
 
J

Jon Peltier

There's a section that covers this in the new book by Bullen and Bovey,
Professional Excel Development. In the technique described therein,
there is a limit of 255 characters, not just on the arguments, but on
the entire string needed to register the function.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Showing argument descriptions as an XLL worksheet function is type 1
Argument limit on user Function? 19
Problem with size limit of function's argument declared in VBA 1
limit on DLL function arguments 4
Excel User Defined function calling RTD 1
Is there a limit for Pivot Tables under Excel 2007 2
Excel UDF implicit range argument 2
Limit an GoTo Function command 1

Top