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?

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?

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?

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