Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I am sure this a simple question. I know how to use functions to return a single value (value as functio name), but I do not know how to use them to return multiple variable and/or arrays of numbers. I need to use a function, but the function needs to return and array o numbers (eg A(1 to X), where X is defined by sub calling the function as well as another value. Do I need to specify these at the start of the function and if so how? Do I need to use the ByRef and/or ParamArray keywords? Help would be appreciate -- biosc ----------------------------------------------------------------------- biosci's Profile: http://www.excelforum.com/member.php...fo&userid=3282 View this thread: http://www.excelforum.com/showthread.php?threadid=53770 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find a Match in Multiple Places & Return Multiple Values | Excel Worksheet Functions | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
Multiple conditions and multiple return values | Excel Worksheet Functions | |||
Search multiple values to return single values | Excel Worksheet Functions | |||
Functions that return multiple calculated values | Excel Programming |