Try doing that with the macro recorder.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norton704" wrote in message
...
I have a spreadsheet & I'm trying to write a macro that:
1) Inserts a new column (& heading)
2) copies what is in 1 column into the next (another new column with a
heading)
Any suggestions?