Swap columns A&B with C&D

C

Cory Thomas

I need to be able to swap columns A&B with C&D but i dont have room o
the side that i will be able to put one off to the side then move bac
over. And i didnt want to have to make a new sheet, copy to the ne
sheet then move back.

I just wanted to know if there was a way to swap them without having t
move the columns and then move them back.

thank
 
B

Bob Phillips

Columns("A:B").Cut
Range("E1").Insert Shift:=xlToRight


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Gord Dibben

Cory

Manually........

Select columns A & B.

Hold SHIFT and ALT keys down while dragging the right edge of B1 to the right.

Drop on C & D which will shift left.

Gord Dibben Excel MVP
 
Top