Move a column
 

I want to move column "E" to column "A" by cutting
column "E" and inserting it to the left of column "A".
i.e. column "A" will become column "B" when its done.

I can do this but it requires at least two lines of code.
Can't this be done in one line of code?

Your example code would be greatly appreciated...thanks in
advance.

Move a column
 

Nope. This overwrites column "A". I need column "A"
shifted to the right...any other ideas?

-----Original Message-----
try
columns(5).cut columns(1)

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"MacroMan" wrote in message
...
I want to move column "E" to column "A" by cutting
column "E" and inserting it to the left of column "A".
i.e. column "A" will become column "B" when its done.

I can do this but it requires at least two lines of
code.
Can't this be done in one line of code?

Your example code would be greatly appreciated...thanks
in
advance.


.

Move a column
 

OK
Columns(6).Cut: Columns(1).Insert shift:=xlToRight
don't forget the colon after cut
--
Don Guillett
SalesAid Software
Granite Shoals, TX

"MacroMan" wrote in message
...
Nope. This overwrites column "A". I need column "A"
shifted to the right...any other ideas?

-----Original Message-----
try
columns(5).cut columns(1)

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"MacroMan" wrote in message
...
I want to move column "E" to column "A" by cutting
column "E" and inserting it to the left of column "A".
i.e. column "A" will become column "B" when its done.

I can do this but it requires at least two lines of
code.
Can't this be done in one line of code?

Your example code would be greatly appreciated...thanks
in
advance.


.