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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
transpose
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) -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
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 |