About Us

Simon[_2_]

(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_]

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?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rules for element-by-element product in array multiplication	Paul	Excel Programming	2	March 22nd 08 11:42 PM
if an element in a row is true then copy whole row to another shee	Don Doan[_2_]	Excel Programming	9	December 14th 07 09:24 PM
Copy destination	Francis Hookham	Excel Programming	4	April 17th 07 02:01 PM
VBA .copy destination	jerredjohnson	Excel Discussion (Misc queries)	2	July 18th 06 11:18 PM
worksheetfunction.transpose - nx1 to n element?	Chris Short	Excel Programming	3	October 24th 05 08:39 AM

Menu

About Us