Excel VBA - Range.Copy transpose paste

excel transpose vba
user1130306 picture user1130306 · Jan 13, 2012 · Viewed 143k times · Source

I'm trying to something very simple, but I seem to be stuck. I am following the help menu for PasteSpecial but I cannot seem to get my code to work without an error.

I want to take Worksheets("Sheet1").Range("A1","A5") and paste transpose to Worksheets("Sheet2").Range("A1","E1").

What is the most simple way to accomplish this?

Answer

GSerg picture GSerg · Jan 13, 2012 
Worksheets("Sheet1").Range("A1:A5").Copy
Worksheets("Sheet2").Range("A1").PasteSpecial Transpose:=True

Related questions

Excel: Formulas for converting data among column / row / matrix

Are there formulas to convert data in a column to a matrix or to a row? And to convert from/to other combinations? What about an even more complex case: reshape a matrix of width W to width N*W? …

Read More
Transposing data from column to row using references

I have some data in a row, say A1 to Z1, and I would like to link to this data in another spreadsheet. However I would like to transpose it so the data runs from A1 to A26. It is …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More