Move a column

  • Thread starter Thread starter MacroMan
  • Start date Start date
M

MacroMan

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.
 
Nope. This overwrites column "A". I need column "A"
shifted to the right...any other ideas?
 
OK
Columns(6).Cut: Columns(1).Insert shift:=xlToRight
don't forget the colon after cut
 
Back
Top