Making Sum ranges Absolute
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 |
All times are GMT +1. The time now is 05:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com