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.