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?