Returning an array from a UDF to a column range

  • Thread starter Thread starter Ron Davis
  • Start date Start date
R

Ron Davis

My experience has been that when I return an array value
from a UDF custom function, it expects to be put into a
row range, i.e. the function call needs to be made from a
row of cells. Is there any way to call an array function
from a column of cells and get the right results? I get
a repeat of the first item in the array when I call from
a column, whereas I get all the array elements when I
call from a row range.

Clarification would be appreciated.
 
where arr is a single dimension array,

Public Function MyFunc(arr)
myfunc = Application.Transpose(arr)
End Function

would work for a column.
 
Back
Top