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 |
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 |
All times are GMT +1. The time now is 10:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com