Hi,
You don't need a macro for this...

Do the following

1. Select all the cells you want to change(Copy)
2. create a new sheet
3. go to the paste special screen
4. check the "Transpose"
5. Click OK

If you don't see what you expected. Please le me know


Annamala