A function can only return values to the cell(s) from which it was called.
If the function is entered into an array of cells, it can return an array to
those cells. See http://www.cpearson.com/Excel/Return...ysFromVBA.aspx
for details and example code.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


"gkk-vba" wrote in message
...
I would like to write a VBA function that takes as input real numbers and
returns more than one value in distinct cells of the worksheet, whose
location can vary dynamically.Specifically I would like a function which
does domething like this.
Function F(x as Double, y as Double, z as Double)
... some code here
F in one cell of the worksheet
G in another cell etc.
End Function
Any help will be appreciated