Ron Davis wrote:

It seems to think that all
arrays are rows!

More likely, your function *defines* the output array as a horizontal
array. As was suggested, instead of finishing up your function with
something like

FunctionName = myArray, try
FunctionName = Application.Transpose(myArray)

Alan Beban


I have a custom function that returns five values as an
array. If I call the array function from a row of five
cells it works fine. But if I call the function from a
column of five cells, it returns the first value of the
return array five times. It seems to think that all
arrays are rows! I thought that an array would be a row
or column depending on circumstances. What rule am I
missing here, or is this an honest error in EXCEL?

Ron Davis
Mathematical Programming Services