VBA Array Formula cant transpose to rows

I have a formula for a spline function that I grabbed off the internets. It will only work if the input ranges and output ranges are columns.

I would really like to use this when inputs and outputs are in rows, but cant figure out how to make it work...Application.transpose() does not help either

any help would be greatly appreciated.

Please Login or Register  to view this content.

Nevermind...I got it.

The formula is set to use columns, so I have to transpose the row inputs to columns, then transpose it back to rows when its done.

Sloppy, but I know how to code better than change the math....

instead of this
Xa = Xa.Value2

I would use this
if Application.caller.rows.count = 1 then Xa = Application.Transpose(Xa.Value2)