Outline.SummaryRow property (Excel)

Returns or sets the location of the summary rows in the outline. Read/write XlSummaryRow.

Syntax

expression.SummaryRow

expression A variable that represents an Outline object.

Remarks

Set XlSummaryRow to xlAbove for Microsoft Word-style outlines, where category headers are above the detailed information.

Set XlSummaryRow to xlBelow for accounting-style outlines, where summations are below the detailed information.

Example

This example creates an outline with automatic styles, with the summary row above the detail rows, and with 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.