Macro to copy and transpose ANY data selection

[TommyGato]

Hey there,
So I am trying to self-teach myself a little bit about macros in Excel because I just started a new job and have some time to kill. I have been doing research all over Google about how to copy and transpose ANY data selection that I make. Every time I try to Record my own macro, it keeps going back to the same cells. I thought that using "Relative References" would help me out, but that really just confuses me further. I specifically would like the data to be copied, pasted special with values and number formats and of course transposed. Anyone willing to help me out? I have been nothing but impressed with the knowledge of the people on this forum. If you want to include some helpful hints and tips that would help too. Thanks so much! Hope someone can help me.

-Cat

[snb]

Help us, post your workbook.