SummaryRow Property

         Example         Applies To

Returns or sets the location of the summary rows in the outline, as shown in the following table. Read/write Long.

Value Meaning
xlAbove The summary row will be positioned above the detail rows in the outline.
xlBelow The summary row will be positioned below the detail rows in the outline.

Remarks

Set SummaryRow to xlAbove for Microsoft Word-style outlines, where category headers are above the detailed information. Set SummaryRow to xlBelow for accounting-style outlines, where summations are below the detailed information.