Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transpose to Non-adjacent Cells
I'm trying to transpose selected rows of data from a worksheet to columns on
multiple worksheets, however the transposed columnar data will be on non-adjacent rows. I loop through the rows, columns, and worksheets. Part of the code within the loops is: Sheets("Equip").Activate Range(Cells(m, 2), Cells(m, 5)).Copy Sheets(s).Cells(7, c).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True Sheets("Equip").Range(Cells(m, 7)).Copy Destination:=Sheets(s).Range(Cells(12, c)) The transpose part of the code works, but I don't know why the second part fails where I'm just trying to copy a single cell. Any help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
Compare 1 cell to column of cells returning adjacent cells info? | Excel Worksheet Functions | |||
Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
transpose array of non-adjacent cells | Excel Worksheet Functions | |||
Transpose a text string while copying adjacent column data to new | Excel Worksheet Functions |