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

--
Message posted from http://www.ExcelForum.com

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)

"Cory Thomas " wrote in message
...
I need to be able to swap columns A&B with C&D but i dont have room on
the side that i will be able to put one off to the side then move back
over. And i didnt want to have to make a new sheet, copy to the new
sheet then move back.

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

thanks


---
Message posted from http://www.ExcelForum.com/

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

On Tue, 15 Jun 2004 13:10:20 -0500, Cory Thomas
wrote:

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

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

thanks


---
Message posted from http://www.ExcelForum.com/