=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
|