Returns or sets the location of the summary rows in the
outline. Read/write XlSummaryRow.
Syntax
property SummaryRow: XlSummaryRow;
Description
SummaryRow can be one of these XlSummaryRow constants.
| xlAbove |
Microsoft Word-style outlines, where category headers are above the detailed information. |
| xlBelow |
Accounting-style outlines, where summations are below the detailed information. |
Example
This example sets SummaryRow property on sheet one to xlAbove.
book.Worksheets[1].Outline.SummaryRow := xlAbove;