Hi i have hundreds of values in an excel workbook with formulas, etc...
I want to be able to write a macro that would autmoatically take th
vertical columns and have all the values go horizontally and vic
versa.

FOr exmaple.

2 3 4 5 6 would be when i run the macro...

2
4
6
7

and when i run the macro again it should be

2 3 4 5 6.

I need this to work from sheet to sheet with lots and lots of data.
am stumped! thanks

--
Message posted from http://www.ExcelForum.com