Passing Range using TRanspose causes Function to Fail

[Bazman2]

Hi there,

When I call the function below: as follows

=bspline(Y16:Y21,X14:X23)

it works fine.

But when I use

=bspline(TRANSPOSE(AC15:AH15),TRANSPOSE(AA14:AJ14))

it gives an error saying one of the inputs is of the wrong data type?

Please Login or Register  to view this content.

[Richard Schollar]

The result of TRANSPOSE is an array rather than a range which is giving you problems.

Richard