VB EXCEL INSERTING COLUMNS

M

moosedog2000

Columns("M:M").Select
Selection.Insert Shift:=xlToRight

This inserts like 5 columns, why is that? Worked fine a few times in a long
macro, but now not so much. Help! I have searhced and searched.
 
B

Barb Reinhardt

Try manually selection column M and see if there are any merged cells that
are selected.
 
M

moosedog2000

thank you, you are correct, I open another worksheet to do my vlookup and
there are in fact merged cells there, good call.
 
Top