I've written a macro that inserts numbers in a column that I want to sum.
When I try to use the sum formula, the cell references change each time a new
number is inserted.

I want to keep the cell ranges constant and not change. The numbers inserted
will never exceed the cell ranges defined.

Thanks,
Ken