View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gkk-vba gkk-vba is offline
external usenet poster
 
Posts: 1
Default Create VBA function that returns many values

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