View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MacroMan MacroMan is offline
external usenet poster
 
Posts: 16
Default Move a column in one line of code

I posted this before, but the suggested response caused
column "A" to be overwritten. I need to retain column "A"!

Previous post:

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.