Creating a Macro

[ArchyJoe]

I was wondering if there was an easier way to Transpose Text from column to Rows, other than copying the cells then right clicking, special paste then selecting transpose. I have to do this about 1000 times and i would like to see if there is an easy macro that might do it for me. any help would be appreciated.


Thanks in Advanced,
Joe

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[bstubbs]

Joe:

I would think that you can record a macro that does it once for a set range and then modify that macro so that it will determine the required range based upon, for instance, the activeCell.

HTH.

Bob