Returns or sets the location of the summary columns in the
outline. Read/write XlSummaryColumn
Syntax
property SummaryColumn: XlSummaryColumn;
Description
SummaryColumn can be one of these XlSummaryColumn constants
| xlLeft |
Summary columns will appear to the left of the detail columns in the outline |
| xlRight |
Summary columns will appear to the right of the detail columns in the outline |
Example
This example sets SummaryColumn property on sheet one to xlSummaryOnLeft
book.Worksheets[1].Outline.SummaryColumn := xlLeft;