Click macro record: copy the range--paste special--
transpose.
Then see what the macro recorded.


-----Original Message-----
I have data in a range A1:Z1. I want to copy this data to
a column, A2:A27. Suggestions or help is most
appreciated! Thank you for your time.

Randy
.