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

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

(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?
 
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
 
You must log in or register to reply here.

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

Similar Threads

Eliminate blanks while copy row and transpose 11
copy value only...Copy Destination:=Cells(3, 2) 3
Help with condensing a lot of copying/pasting... 4
Copying Filtered Data from multiple worksheets 3
Copy Destination fails 2
paste transpose array of variables 2
Selecting Range of Copied Text 2
Array with many cells from a row but not in order or together 11

Back
Top