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