View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
biosci[_7_] biosci[_7_] is offline
external usenet poster
 
Posts: 1
Default Functions that return multiple values


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