| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move rows from column to column | New Users to Excel | |||
| numbers in a column and it changes when I move to the next column | Excel Discussion (Misc queries) | |||
| how to move the cursor to column A after entering data column F | New Users to Excel | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
| Move text from column B to column A | Excel Discussion (Misc queries) | |||
Linear Mode
