 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Languages / VB.NET / October 2004limitation on number of arguments for VB func. called from excel?
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.  SignatureKen 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. > 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 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. SignatureKen 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. > Hi, > [quoted text clipped - 10 lines] > > functions, the box where I can fill out the arguments does not come up. > > The arguments are of different types: long, double and range. Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.