VB EXCEL INSERTING COLUMNS

G

Guest

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.
 
G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem inserting rows (and cutting) 2
Macro to insert and move columns 3
Please Help: Macro Nearly Finished 1
Changing Column Reference in Macros? 2
Insert columns and values programmatically with IF statement 9
moving all data to cell a1 4
can't paste from clipboard in my macro 1
macro deletes wrong columns 4

Top