macro to change rows to columns

Originally Posted by nimrod

Have you tried using the pastespecial function "Transpose" ? It takes the selected rows and changes them to columns ... and visa/versa.

I think I may have explained my problem poorly originally. My problem is I have only one long row that I want to change into several rows. I need every 20 cells in this one row to be on a new row. I'm stuck...

Thanks