| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert or delete rows without losing formulas
I have a sheet that has formulas on it. Sometimes I need to insert or delete
rows and have the exisiting formulas automatically copied or deleted as necessary without corrupting the existing formulas. Is there a way to do this? Thanks in anticipation of a favourable reply |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
insert or delete rows without losing formulas
Hi John,
See my pages Insert a Row using a Macro to maintain formulas http://www.mvps.org/dmcritchie/excel/insrtrow.htm You will probably also have to change formulas referring to other rows to use OFFSET as mentioned in the above artcle Using OFFSET to maintain formulas http://www.mvps.org/dmcritchie/excel/offset.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "John Davies" wrote in message ... I have a sheet that has formulas on it. Sometimes I need to insert or delete rows and have the exisiting formulas automatically copied or deleted as necessary without corrupting the existing formulas. Is there a way to do this? Thanks in anticipation of a favourable reply |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert a row without losing data in INDEX formulas | Excel Worksheet Functions | |||
| Insert rows: Formats & formulas extended to additonal rows | Excel Worksheet Functions | |||
| Automatically insert/delete rows to be x apart | Excel Discussion (Misc queries) | |||
| Insert/delete rows | Excel Programming | |||
| Deleting rows without losing formulas | Excel Programming | |||
Linear Mode
