Cut & Paste

[STEVEB]

I would like to have column A cut and put between column B & C, does
anyone have any suggestions?

Thanks

 

[Guest]

-----Original Message-----
I would like to have column A cut and put between column B & C, does
anyone have any suggestions?

Thanks



------------------------------------------------
[/url]
~~ View and post usenet messages directly from http://www.ExcelForum.com/

.

Go to colum a click on the a tap then right click then cut
then click on c tap and right click then hit insert cut
cell this will put a in the middle of b and cJD

 

[Tom Ogilvy]

Sub CutATOB()

Columns("A:A").Cut
Columns("C:C").Insert Shift:=xlToRight
End Sub

 

[STEVEB]

Thanks Tom, it worked great