Share via

Outline.SummaryColumn Property

  • Article
Excel Developer Reference

Returns or sets the location of the summary columns in the outline. Read/write XlSummaryColumn.

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

See Also