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

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

View Single Post

#1

Report Post

Posted to microsoft.public.excel.programming

Simon[_2_] Simon[_2_] is offline

Simon[_2_] is offline

external usenet poster

Posts: 89

Default

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

Reply With Quote

Reply With Quote