Friends,

I know how to copy / paste special / transpose, but I cannot get the
TRANSPOSE() worksheet function to work. Let's say I have 1,2,3 in the
horizontal array A1:C1. What, exactly, do I do to transpose the 1,2,3 into a
vertical array in (A1:A5), using only the TRANSPOSE() worksheet function.

I keep getting the #Value# error, so I must be missing something.

Thanks for your help ...

Bill Morgan