View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Move a column in one line of code

two lines of code written on a single line? Does that qualify? LOL

Regards,
Tom Ogilvy

Dave Peterson wrote in message
...
But Don posted an alternative suggestion.

MacroMan wrote:

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.


--

Dave Peterson