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

=SUM(INDIRECT("A1:A10"))
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Ken" wrote in message
...
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