Returning an array from a UDF to a column range
 

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.

Returning an array from a UDF to a column range
 

where arr is a single dimension array,

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

would work for a column.

--
Regards,
Tom Ogilvy

Ron Davis wrote in message
...
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.