Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving entire column
I did a search here, but must be searching on the wrong criteria, as I
didn't find anything relevant. I want to move an entire column, column "F" over to column "A", forcing "A" to "B". Some kind of cut and entire.column insert, like: rTitle.EntireColumn.Cut rTitle.Column("A:A").EntireColumn.Insert <---- APPLICATION DOES NOT SUPPORT THIS OBJECT OR METHOD Does anyone see where the error is? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving entire column
Use this
Columns("F").Cut Range("A1").Insert Shift:=xlToRight -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "davegb" wrote in message ... I did a search here, but must be searching on the wrong criteria, as I didn't find anything relevant. I want to move an entire column, column "F" over to column "A", forcing "A" to "B". Some kind of cut and entire.column insert, like: rTitle.EntireColumn.Cut rTitle.Column("A:A").EntireColumn.Insert <---- APPLICATION DOES NOT SUPPORT THIS OBJECT OR METHOD Does anyone see where the error is? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving entire column
You don't really say what rtitle is
Sub movecolf() Columns("f").Copy Columns("a").Insert Columns("f").Delete 'or clearcontents End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "davegb" wrote in message ... I did a search here, but must be searching on the wrong criteria, as I didn't find anything relevant. I want to move an entire column, column "F" over to column "A", forcing "A" to "B". Some kind of cut and entire.column insert, like: rTitle.EntireColumn.Cut rTitle.Column("A:A").EntireColumn.Insert <---- APPLICATION DOES NOT SUPPORT THIS OBJECT OR METHOD Does anyone see where the error is? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving entire column
So you don't have to wait for replies, a time saver can be using the macro
recorder. Tools-Macro-Record New Macro... It works for some of the simpler things though at points, it includes some unnecessary coding. "davegb" wrote: I did a search here, but must be searching on the wrong criteria, as I didn't find anything relevant. I want to move an entire column, column "F" over to column "A", forcing "A" to "B". Some kind of cut and entire.column insert, like: rTitle.EntireColumn.Cut rTitle.Column("A:A").EntireColumn.Insert <---- APPLICATION DOES NOT SUPPORT THIS OBJECT OR METHOD Does anyone see where the error is? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving entire column
On Tue, 8 Jul 2008 08:44:01 -0700, StumpedAgain wrote:
So you don't have to wait for replies, a time saver can be using the macro recorder. Tools-Macro-Record New Macro... It works for some of the simpler things though at points, it includes some unnecessary coding. "davegb" wrote: I did a search here, but must be searching on the wrong criteria, as I didn't find anything relevant. I want to move an entire column, column "F" over to column "A", forcing "A" to "B". Some kind of cut and entire.column insert, like: rTitle.EntireColumn.Cut rTitle.Column("A:A").EntireColumn.Insert <---- APPLICATION DOES NOT SUPPORT THIS OBJECT OR METHOD Does anyone see where the error is? Thanks Thanks to all of you. Got it working! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding and then moving entire row to new sheet based on cell value | Excel Discussion (Misc queries) | |||
Moving an entire range and a for loop question | Excel Programming | |||
cutting entire rows based on conditions and moving to new tab | Excel Programming | |||
Moving An Entire Row From One Sheet To Another | Excel Discussion (Misc queries) | |||
Moving entire rows | Excel Programming |