To overwrite the existing Column A with Column F (and F is deleted)

Columns(6).Cut Columns(1)

To insert before column A and delete F

Sub AAB()
Columns(6).Cut
Columns(1).Insert
End Sub

--
regards,
Tom Ogilvy

"andysgirl8800"
wrote in message
news:andysgirl8800.28du3y_1148592602.1133@excelfor um-nospam.com...

thank you so much! knew it had to be simple! is it just as simple to
move column F to column A?


--
andysgirl8800
------------------------------------------------------------------------
andysgirl8800's Profile:
http://www.excelforum.com/member.php...o&userid=34752
View this thread: http://www.excelforum.com/showthread...hreadid=545666