Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I currently have the following, which of course breaks down once you hit the
limit of 29 arguments in a user defined function: In the Worksheet: =Newton(B11,B12,B13,B14,B15,B16,B17,B18,B19,B20,B2 1,B22,B23, B24,B25,B26,B27,B28,B29,B30,B31,B32,B33,B34,B35,B3 6,B37,B38, B39,B38) In VB: Function Newton(P, n, F, A1, m1, A2, m2, A3, m3, A4,m4, A5,m5,A6, m6, A7, m7, A8, m8, A9, m9, A10,m10, A11, m11, A12, m12, A13, m13, iannual) To redesign, I have: In the Worksheet: =Newton(B11:B39,B8) In VB: Function Newton(.......?) ?? Any help here to make this work is appreciated. I can't seem to ge this to work. -- Thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workaround for HYPERLINK argument length limit | Excel Worksheet Functions | |||
How can I get around 30 argument limit of SUM function? | Excel Worksheet Functions | |||
If I get the help box up by hitting F1 by mistake, how can I get . | Excel Discussion (Misc queries) | |||
Argument limit in Excel Function Wizard | Excel Programming | |||
Argument limit on user Function? | Excel Programming |