| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tannspose and cycle
Hello
In Excel 2003 I have the sheet1 A2:02 to A832:0632 How can I write this code in a cycle Range("A2:O2").Select Selection.Copy Sheets("Sheet2").Select Range("A1").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True Range("A3:O3").Select Selection.Copy Sheets("Sheet2").Select Range("A19").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True Range("A4:O4").Select Selection.Copy Sheets("Sheet2").Select Range("A37").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True And so on to A632:0632 Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a graph with 2-cycle X 3-cycle log-log graph paper? | Charts and Charting in Excel | |||
| cycle time | Charts and Charting in Excel | |||
| cycle thru controls | Excel Programming | |||
| How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
| Cycle through all worksheets | Excel Programming | |||
Threaded Mode
