SummaryColumn Property

Applies To

Outline Object.

Description

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

Value

Meaning

xlLeft

The summary column will be to the left of the detail columns in the outline.

xlRight

The summary column will be to the right of the detail columns in the outline.


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