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

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?

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

Post your code...
--
HTH...

Jim Thomlinson


"lostatlewisu" wrote:

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?

Recorded single column insert in macro. Macro inserts two 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.

"lostatlewisu" wrote:

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?

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

Do you have merged cells in your worksheet?

lostatlewisu wrote:

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?

--

Dave Peterson