Cut & Paste
 

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

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Cut & Paste
 

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

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ 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 c

JD

Cut & Paste
 

Sub CutATOB()

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

--
Regards,
Tom Ogilvy

"STEVEB" wrote in message
...
I would like to have column A cut and put between column B & C, does
anyone have any suggestions?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Cut & Paste
 

Thanks Tom, it worked great



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/