I'm creating a macro that uses a selected form with several preinserted
sections (with a header, two item descriptions, then costing totals at the
bottom of each section). At the very bottom of the form, I have the Form
Totals, which adds up all the totals from each section above.

My question is, the macro will be used to insert a new section just above
the total line. How do I write the VBA code (using Excel 2000), to insert
the formula on the Section Total Line for each of the 4 columns in the
section.

For example:

Item Description 1 100 200 300 400
Item Description 2 250 250 450 850

Section Total 350 450 750 1250

I need to use the SUM so I can add more descriptions individually later.

I know this has been done many times before, but I'm having trouble figuring
it out. Any help would be appreciated. Thanks.