move entire column
 

How can I move column H over to Column B using VBA. I want to insert it
between the existing Col A And B So that Col H becomes Col B and the
existing Col B becomes C, and so forth...

Thank you

QB

move entire column
 

Sub MoveH()
Columns("H").Cut
Columns("B").Insert
End Sub
"QB" wrote in message
...
How can I move column H over to Column B using VBA. I want to insert it
between the existing Col A And B So that Col H becomes Col B and the
existing Col B becomes C, and so forth...

Thank you

QB

move entire column
 

Record a macro while you do it. HTH Otto
"QB" wrote in message
...
How can I move column H over to Column B using VBA. I want to insert it
between the existing Col A And B So that Col H becomes Col B and the
existing Col B becomes C, and so forth...

Thank you

QB