Move columns VBA without cut and paste.

[dimitri]

Hi,
Is there a way to move columns around using VBA without cutting and pasting? For example, move column B between columns E and F without using the cut and paste methods in VBA. the reason being that I don't want to fill up my clip board. Thanks.

 

[HalfAce]

Move column F to the right, move column B to the (new) column F and delete the old column B - all without copying, cutting or pasting. (right?)

Sub MoveColumnBDemo()
Columns(6).EntireColumn.Insert
Range("F:F").Value = Range("B:B").Value
Columns(2).EntireColumn.Delete
End Sub

Note that because there's no copying being done, all you'll get transfered are the values of column B, not any formulas or formatting that might be there.

Hope it helps.

 

[dimitri]

That's perfect. Thank you!

 

[HalfAce]

Most welcome. Glad it helped.