SummaryRow Property

Applies To

Outline Object.

Description

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

Value

Meaning

xlAbove

The summary row will be above the detail columns in the outline.

xlBelow

The summary row will be below the detail columns in the outline.


Remarks

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

Example

This example creates an outline with automatic styles, the summary row above the detail rows, and the summary column to the right of the detail columns.


Worksheets("Sheet1").Activate
Selection.AutoOutline
With ActiveSheet.Outline
    .SummaryRow = xlAbove
    .SummaryColumn = xlRight
    .AutomaticStyles = True
End With