| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cut/paste columns efficiency
I am currently clearing/cutting/pasting columns using the below code.
Is there a more efficient way of doing this? Columns("A:B").ClearContents Columns("E:H").ClearContents Columns("J").ClearContents Columns("M:Q").ClearContents Columns("T").ClearContents Columns("V:Z").ClearContents Columns("AC").ClearContents Columns("I").Cut Range("E1").Select ActiveSheet.Paste Columns("AA:AB").Cut Range("F1").Select ActiveSheet.Paste Columns("K:L").Cut Range("H1").Select ActiveSheet.Paste Columns("U").Cut Range("J1").Select ActiveSheet.Paste Columns("C:J").Cut Range("A1").Select ActiveSheet.Paste Columns("S").Cut Range("I1").Select ActiveSheet.Paste Columns("R").Cut Range("J1").Select ActiveSheet.Paste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Efficiency in code | Excel Programming | |||
| Efficiency of Code Help | Excel Programming | |||
| efficiency | Excel Programming | |||
| VBA Efficiency Question | Excel Programming | |||
| VB Efficiency: Inserting a Row | Excel Programming | |||
Threaded Mode
