Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move Column within Sheet with VB Macro
I'd like to move a column in between existing columns and possibly have the
results pasted as values. I've been searching through the posting but haven't found anything I could use. Would appreciate your help. Thanks James |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move Column within Sheet with VB Macro
Turn on the macro recorder whilst you do these steps.
1. Select column B and hold SHIFT key. 2. Position cursor on the side of C1 then move to left of column F. 3. CopyPste SpecialValuesOKEsc. On Wed, 30 May 2007 10:38:03 -0700, Letzdo_1t wrote: I'd like to move a column in between existing columns and possibly have the results pasted as values. I've been searching through the posting but haven't found anything I could use. Would appreciate your help. Thanks James |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move Column within Sheet with VB Macro
How about side of B1, not C1<g
Gord On Wed, 30 May 2007 13:27:46 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Turn on the macro recorder whilst you do these steps. 1. Select column B and hold SHIFT key. 2. Position cursor on the side of C1 then move to left of column F. 3. CopyPste SpecialValuesOKEsc. On Wed, 30 May 2007 10:38:03 -0700, Letzdo_1t wrote: I'd like to move a column in between existing columns and possibly have the results pasted as values. I've been searching through the posting but haven't found anything I could use. Would appreciate your help. Thanks James |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move Column within Sheet with VB Macro
Gordon - Much thanks for your help, not only did I get the VB code
I'm looking for - I've just learned an easier way of recording a macro. Thanks again, James VB Code: Columns("B:B").Select Selection.ColumnWidth = 6.14 Columns("B:B").Cut Destination:=Columns("F:F") Columns("F:F").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False "Gord Dibben" wrote: Turn on the macro recorder whilst you do these steps. 1. Select column B and hold SHIFT key. 2. Position cursor on the side of C1 then move to left of column F. 3. CopyPste SpecialValuesOKEsc. On Wed, 30 May 2007 10:38:03 -0700, Letzdo_1t wrote: I'd like to move a column in between existing columns and possibly have the results pasted as values. I've been searching through the posting but haven't found anything I could use. Would appreciate your help. Thanks James |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move Column within Sheet with VB Macro
Even with the typo<g
Thanks for the feedback, Gord On Wed, 30 May 2007 14:59:02 -0700, Letzdo_1t wrote: Gordon - Much thanks for your help, not only did I get the VB code I'm looking for - I've just learned an easier way of recording a macro. Thanks again, James VB Code: Columns("B:B").Select Selection.ColumnWidth = 6.14 Columns("B:B").Cut Destination:=Columns("F:F") Columns("F:F").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False "Gord Dibben" wrote: Turn on the macro recorder whilst you do these steps. 1. Select column B and hold SHIFT key. 2. Position cursor on the side of C1 then move to left of column F. 3. CopyPste SpecialValuesOKEsc. On Wed, 30 May 2007 10:38:03 -0700, Letzdo_1t wrote: I'd like to move a column in between existing columns and possibly have the results pasted as values. I've been searching through the posting but haven't found anything I could use. Would appreciate your help. Thanks James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to move a column from one sheet to another by using functions | Excel Discussion (Misc queries) | |||
Move Macro Button on Sheet to a toolbar | Excel Discussion (Misc queries) | |||
Macro to move data from one sheet to another | Excel Discussion (Misc queries) | |||
how do i write a macro to move down in the sheet one line ? | New Users to Excel | |||
Macro to move to next column | Excel Discussion (Misc queries) |