Moving entire column

  • Thread starter Thread starter davegb
  • Start date Start date
D

davegb

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
 
You don't really say what rtitle is
Sub movecolf()
Columns("f").Copy
Columns("a").Insert
Columns("f").Delete 'or clearcontents
End Sub
 
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.
 
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.
Click to expand...

Thanks to all of you. Got it working!
 
Back
Top