Hi,

I've created a UDF which I call through a matrix function on the excel
sheet which is located in a column.

Up till now functions allways returned a column vector containing the
values assigned.

Now however if I assign a 1 dimensional variable the UDF now returns a
row vector, but I have no idea what I do different.

How does VBA.Excel decide what type to return and how can I control
it.