transpose

[Yngve]

Hi all

I us CopyRangeFromMultiWorksheets from RonDeBruin and have
Fill in the range like this
Set CopyRng = sh.Range("A23,A24,A25"), on DestSh it fill inn
a1,a2,a3, next a4,a5,a6 son on, is it posible to transpose
to a1,b1,c1


With DestSh.Cells(Last + 1, "A")
.PasteSpecial.transpose = true <----------have tryd
to put in, but get error
.PasteSpecial xlPasteValues
'.PasteSpecial xlPasteFormats
Application.CutCopyMode = False
End With


can somone help me with this.

Thanks


Yngve

 

[GS]

Yngve expressed precisely :

Hi all

I us CopyRangeFromMultiWorksheets from RonDeBruin and have
Fill in the range like this
Set CopyRng = sh.Range("A23,A24,A25"), on DestSh it fill inn
a1,a2,a3, next a4,a5,a6 son on, is it posible to transpose
to a1,b1,c1


With DestSh.Cells(Last + 1, "A")
.PasteSpecial.transpose = true <----------have tryd
to put in, but get error
.PasteSpecial xlPasteValues
'.PasteSpecial xlPasteFormats
Application.CutCopyMode = False
End With


can somone help me with this.

Thanks


Yngve

Transpose is a worksheet function and so you should look that up to
learn more about how it works and how to use it.

In code, you use it like this:

rngTarget = WorksheetFunction.Transpose(rngSource)