Muokkaa

Jaa

Outline.SummaryColumn property (Excel)

  • Artikkeli

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

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.