Avoiding Clipboard

[Jlascu]

Hi to all,

Apologies if this has been addressed before.
I've been trying to copy values from one workbook and paste them transposed on a different workbook.
The current macro using copy/paste transpose works well and does the trick, but takes forever to run.
is there a way to avoid using the clipboard?

many thanks in advance!

Jose

 

[Jlascu]

it worked! many thanks!! i'll keep coding and this helps program run faster!!
so many thanks again!

 

[RoryA]

Just FYI, the issue was the use of Windows rather than Workbooks in this line:

Windows(sDPMPName).Worksheets("Exp").Range(sImportRangePaste).Resize(rng.Columns.Count, rng.Rows.Count).Value = Application.Transpose(rng)

Change that to Workbooks and it should work.