|Subject:||Formula doesn't adjust when Inserting a row into a range|
|Posted by:||David (anonymo…@discussions.microsoft.com)|
|Date:||Fri, 17 Oct 2003|
I am building a budget using outlining in order to show
detail for a particular total. I want to start out the
budget with only one detail line per budget, and then
write a macro to allow the user to insert a detail line.
The problem I have is that when I use the insert command
the formula for the total below the detail line doesn't
adjust to include the new detail line.
Any ideas? I would really appreciate the help.