Excel.Outline.SummaryColumn.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Outline.SummaryColumn property (Excel)	vbaxl10.chm455075	vbaxl10.chm455075	Excel.Outline.SummaryColumn	b134c991-7875-445a-ca73-d48bf23f3eea	05/02/2019	medium

Outline.SummaryColumn property (Excel)

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.

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

[!includeSupport and feedback]