ExcelBanter - Copy _ Destination := Range, Transpose:=True? Can it work?

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

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

- - Copy _ Destination := Range, Transpose:=True? Can it work? (https://www.excelbanter.com/excel-programming/415865-copy-_-destination-%3D-range-transpose-%3Dtrue-can-work.html)

Simon[_2_]

Copy _ Destination := Range, Transpose:=True? Can it work?

I have:

CalcSheetv2.Worksheets(1).Range("B31:Q31").Copy _
Destination:=NEWSELBilling.Worksheets(1).Range("L6 5536").End(xlUp).Offset(1,
0), Transpose:=True

How can I get the Transpose to work?

Answers greatly appreciated thanks

Jim Thomlinson

Copy _ Destination := Range, Transpose:=True? Can it work?

You need to use paste special and not an ordinary paste if you want to
transpose...
--
HTH...

Jim Thomlinson

"Simon" wrote:

I have:

CalcSheetv2.Worksheets(1).Range("B31:Q31").Copy _
Destination:=NEWSELBilling.Worksheets(1).Range("L6 5536").End(xlUp).Offset(1,
0), Transpose:=True

How can I get the Transpose to work?

Answers greatly appreciated thanks

All times are GMT +1. The time now is 08:13 PM.