Syntax

expression.SummaryColumn

expression A variable that represents an Outline object.

Remarks

XlSummaryColumn can be one of these XlSummaryColumn constants.
xlSummaryOnRight The summary column will be positioned to the right of the detail columns in the outline.
xlSummaryOnLeft The summary column will be positioned to the left of the detail columns in the outline.

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.

Visual Basic for Applications
Worksheets("Sheet1").Activate Selection.AutoOutline With ActiveSheet.Outline .SummaryRow = xlAbove .SummaryColumn = xlRight .AutomaticStyles = True End With
summary summary column summarycolumn summarycolumn property

See also: