ExcelBanter - Can you someone use Copy Destination:= using a transpose element?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can you someone use Copy Destination:= using a transpose element? (https://www.excelbanter.com/excel-programming/415852-can-you-someone-use-copy-destination-%3D-using-transpose-element.html)

Simon[_2_]

Can you someone use Copy Destination:= using a transpose element?

(Have) I understood (correctly?) that the Copy Paste using the
clipboard is less favourable then the Copy Destination? Yet how can I
add a paste special with transpose :=True?

Rick Rothstein \(MVP - VB\)[_2619_]

Can you someone use Copy Destination:= using a transpose element?

I think you will have to do it like this...

Worksheets("Source").Range("B3:H6").Copy
Worksheets("Destination").Range("J2").PasteSpecial Transpose:=True
Application.CutCopyMode = False

Rick

"Simon" wrote in message
...
(Have) I understood (correctly?) that the Copy Paste using the
clipboard is less favourable then the Copy Destination? Yet how can I
add a paste special with transpose :=True?

All times are GMT +1. The time now is 03:37 AM.