deleting rows messing up sums
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.
|