| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing an array in a user defined function
I am wondering that, in the below post from Charles, after declaring "Array1
as Variant" in the user-defined function name, then in the UDF codes, should we declare Array1 again for its dimension(s)? Basically, how to make use of Array1 in the UDF, if Array1 has been defined somewhere else? Thanks, Laurie "Charles Williams" wrote: On the Worksheet =FunctionName({1,2,3,4,5},constant) in the VBA function you then have to assign to a Variant Function FunctionName(Array1 as variant, Constant as ...) as ... Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Peter M" wrote in message ... How do I pass an array in a user defined function? E.g., =FunctionName(Array1, Constant, ...) -- Thanks for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range to a user defined function | Excel Discussion (Misc queries) | |||
| Creating a User Defined Array Function | Excel Programming | |||
| passing named range to a UDF user defined function | Excel Programming | |||
| passing a range to a user defined function using a form | Excel Programming | |||
| Passing an Array of User-Defined Type to an Argument of a Function | Excel Programming | |||
Hybrid Mode
