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

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