Change Row into a Column

[Djblois]

Is there a way to transpose Range("D3:G3") into Range("A1:A3")? Basically I want to change a row of data into a column of data.

[mikerickson]

Yes. Copy / Paste Special with the Transpose option checked.

[Djblois]

I never used that before thank you

[mdmackillop]

Here's a KB Item (http://vbaexpress.com/kb/getarticle.php?kb_id=144) if you need to link the column to the row.