Swap columns A&B with C&D

[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

 

[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)

 

[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