Hi. I have a list of numbers in C26 through C36. Cell
C37 sums these. I need for the user to be able to add
rows and have the summation cell change accordingly.
This works unless the user inserts a row after the last
row.

Is there a way, through programming or otherwise, to make
the formula change even in this situation? I do have a
variable in my macro called "lastRow" that records the
row number of the summation row (currently 37).

Thanks,
Mike.