| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert column in
Brilliant! Thanks!!!
"Tom Ogilvy" wrote: maybe something like this: Sub EFG() Set r = Range("MyRange") r(r.Columns.Count - 4).EntireColumn.Insert r.Columns(r.Columns.Count - 4).Copy _ r.Columns(r.Columns.Count - 5) End Sub -- Regards, Tom Ogilvy "blonde1030" wrote: I would like a macro to insert a column (not just cells) in a named range. The new column location would be 5 in from the last column in the range, and it would need to have the same formulas as the column to its right. Any help is appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Column after specific text title the new column and add for | Excel Discussion (Misc queries) | |||
| insert a blank column between each column in a data file | Excel Discussion (Misc queries) | |||
| insert row / insert column command buttons | Excel Worksheet Functions | |||
| Macro - Insert&Label Column, if the labeled column doesn't exist | Excel Programming | |||
| Need Macro to Find Column Heading -- if none, then insert new column | Excel Programming | |||
Hybrid Mode
