When I try to set up a sum function in macro, the vertical range of
the sum becomes an absolute range that does not expand when I try to
add rows between the first and last row of the range set in the macro.
The range does not expand. It seems to be anchored at the top of the
range and only extends the number of cells down that was set in the
macro. How do I set up a sum range that allows new rows to be added
inside the range and make the range expand to include the new row of
cells?

Rather than modify the macro change the way you add rows. I usually add a
new row by highlighting a row with the formual and press right mouse button
and click copy. Then right click the highlighted row number and insert
copied row. This will keep all the formulas intact and the Sum of the
columns will also be updated.

" wrote:

When I try to set up a sum function in macro, the vertical range of
the sum becomes an absolute range that does not expand when I try to
add rows between the first and last row of the range set in the macro.
The range does not expand. It seems to be anchored at the top of the
range and only extends the number of cells down that was set in the
macro. How do I set up a sum range that allows new rows to be added
inside the range and make the range expand to include the new row of
cells?