Are you using absolute references in your formulas eg $A$4 rather than
A4?

If the problem you are having relates to formulas in the row after the
one you delete, as a quick and simple solution you could add this line
after the one that deletes your rows;

cells(activerow,columnwithformulasin).formular1c1 =
cells(activerow-1,columnwithformulasin).formula

where activerow is the row after the one that has been deleted
(presumably the one with error formula) and columnwithformulas in is a
number relating to the columm your totals are in, ,eg column E = 5

Please be more specific with regards your formulas if this is not
relevant.
Cheers.

Hi ......,

Without the formulas that you are using and an example of what happens
I expect that you are talking about problems with a running balance
being dependent on the previous row  which got deleted or missed
an inserted row in the running balance.    If that is the case you want
to use OFFSET see
   http://www.mvps.org/dmcritchie/excel/offset.htm
   http://www.mvps.org/dmcritchie/excel/insrtrow.htm

This would also apply the the final total,  if you delete the row before
the total or insert a row immediately before the total.
---
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