Formula doesn't adjust when Inserting a row into a range

Giganews Newsgroups
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.

David

Replies