| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Columns Reference in VBA after inserting a new column
Hi All,
I have a workbook which seems to be ever evolving, and means i often add in extra columns which throws out the formulas i have within. Eg: I'm using formulas like this. ActiveSheet.Range(Cells(4, 7), Cells(myrowcount, 6)).Formula = "=IF(S4<"""",""ORD"",IF(L4(J4+K4),""Yes"",IF(H4< =8,""Yes"",""No"")))" Each time I add in a new column, it means i have to redo each formula I have. What's the best way to handle this?? My Column headings don't change, so could I use a "Match("ColumnHeader" type statement??? Any help would be appreciated. Thanks.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Inserting Columns and then add column to horizontal total | Excel Discussion (Misc queries) | |||
| Inserting new columns past the last column | Excel Discussion (Misc queries) | |||
| Maintain Relative Reference After Inserting a Column | Excel Worksheet Functions | |||
| Inserting new column between the columns | Excel Programming | |||
| Formulas: Keeping same row/column reference when columns are inser | Excel Discussion (Misc queries) | |||
Threaded Mode
