| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB EXCEL INSERTING COLUMNS
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VB EXCEL INSERTING COLUMNS
Try manually selection column M and see if there are any merged cells that
are selected. "moosedog2000" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VB EXCEL INSERTING COLUMNS
thank you, you are correct, I open another worksheet to do my vlookup and
there are in fact merged cells there, good call. "Barb Reinhardt" wrote: Try manually selection column M and see if there are any merged cells that are selected. "moosedog2000" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting new columns | Excel Discussion (Misc queries) | |||
| Inserting columns into a row | Excel Discussion (Misc queries) | |||
| inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
| Pivot tables - inserting columns | Excel Worksheet Functions | |||
| Inserting Columns | Excel Worksheet Functions | |||
Linear Mode
