Functions returning multiple answers

[Clint]

Is there a way to write a function that will return
multiple answers? The function that I would like to
write would have 3 values passed to it and will perform
calculations and I would ultimately like to return about
4-5 of the calculations. Otherwise, this would all have
to be done in a sub which would greatly add to the code.
Thanks!

 

[Frank Kabel]

Hi
a function in a worksheet cell or even directly in code can only return
one value. But you may have a look at
ByRef
for declaring your variables

 

[Tom Ogilvy]

Or you could have the function return an array of values.