Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
transpose
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose | Excel Worksheet Functions | |||
transpose | Excel Programming | |||
Transpose from Col to row | Excel Programming | |||
transpose | Excel Worksheet Functions | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions |