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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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?
Click to expand...
 
Back
Top