move entire column

[QB]

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

 

[Bob Umlas]

Sub MoveH()
Columns("H").Cut
Columns("B").Insert
End Sub

 

[Otto Moehrbach]

Record a macro while you do it. HTH Otto