Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How give VBA function more than 29 input arguments?
I am writing a financial planning application as a function that takes many
input variables, they went from 28 (which was fine) to 43 (I get error message, which mean that only 29 inputs are allowed). How can I give the function 43 inputs? VBA documentation says they should accept up to 60! Thanks. ... Lancish |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How give VBA function more than 29 input arguments?
VBA function (in code?) or worksheet function?
I don't know what the limits of args to a VBA Sub or Function is, but if the number of args gets large, I would usually use a collection, array, string, ParamArray, range or read from a stream (e.g., file) of some kind. Virtually no limits. If worksheet function, well, others are more adept. "lancish" wrote in message ... I am writing a financial planning application as a function that takes many input variables, they went from 28 (which was fine) to 43 (I get error message, which mean that only 29 inputs are allowed). How can I give the function 43 inputs? VBA documentation says they should accept up to 60! Thanks. ... Lancish |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How give VBA function more than 29 input arguments?
Assuming you are developing a worksheet function, 43 input variables would
present huge useability problems for users. And Excel does not allow it anyway. Use a small number of Range arguments that refer to large numbers of adjacent cells instead. Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "lancish" wrote in message ... I am writing a financial planning application as a function that takes many input variables, they went from 28 (which was fine) to 43 (I get error message, which mean that only 29 inputs are allowed). How can I give the function 43 inputs? VBA documentation says they should accept up to 60! Thanks. ... Lancish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Has Too Many Arguments | Excel Worksheet Functions | |||
function arguments | Excel Discussion (Misc queries) | |||
IF function with too many arguments | Excel Worksheet Functions | |||
If Function with 3 arguments | Excel Worksheet Functions | |||
Function Arguments | Excel Worksheet Functions |