E
ExcelMonkey
If I copy and paste special a transposed range, it records like this:
Range("D2
14").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
14").Copy Destination:= Range("A1")
Thank
Range("D2

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

Thank