View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] idyllicabyss@googlemail.com is offline
external usenet poster
 
Posts: 32
Default 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.