Paste Special and Transpose range

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

If I copy and paste special a transposed range, it records like this:


Range("D2:D14").Select
Selection.Copy
Sheets("Stochastic Output").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone
SkipBlanks :=False, Transpose:=True

But if I want to write it like below, how do I incorporate th
transpose method?

Range("D2:D14").Copy Destination:= Range("A1")

Thank
 
Range("D2:D14").Copy
Range("A1").PasteSpecial Transpose:=True
Application.CutCopyMode = False

Alan Beban
 
Range("D2:D14")..Copy
Sheets("Stochastic Output").Range("A1"). _
PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, _
Transpose:=True

You still have to use two steps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top