Recorded single column insert in macro. Macro inserts two not one

[Guest]

I am recording a macro that will delete some columns and then insert one
column. After I stop the recording and run the macro it inserts two columns
not one?

 

[Guest]

Post your code...

 

[Guest]

You have to select one column before you do an insertion. When you highligh
multilple columns it deletes these column, but more than one column is
highlighted. If you then add columns, it will add as many column back as you
have highlighted.

 

[Dave Peterson]

Do you have merged cells in your worksheet?

I am recording a macro that will delete some columns and then insert one
column. After I stop the recording and run the macro it inserts two columns
not one?