SUM

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

i am having a problem with a spreadsheet i designed. i
made a macro which inserts a row at the bottom of the
sheet and autofills the corresponding cells with the
corresponding formulas. my problem is that i have a
sumation at the end of one of the columns (right under the
inserted row), and it refused to take into account the new
row. i tried doing the offset method, for example, =SUM
(A1:OFFSET(A11,-1,0)), however, that did not solve my
problem. i also tried making it part of the macro, but it
did not work either. i think that excel is not reacting
to the new row inserted by the macro, which is why it
won't accept it in the sumation. how can i fix this?
thank you for your time.
andrea
 
What I usually do is leave a blank row between the end of my data and my SUM
formula and I include that blank row in the formula. When I manually insert
a row at the blank row, the formula automatically updates. I would imagine
this would work when a row is inserted with a macro as well.
 
Back
Top