PivotTable.SelectionMode Property

Returns or sets the PivotTable report structured selection mode. Read/write XlPTSelectionMode.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property SelectionMode As XlPTSelectionMode
    Get
    Set
'Usage
Dim instance As PivotTable
Dim value As XlPTSelectionMode

value = instance.SelectionMode

instance.SelectionMode = value
XlPTSelectionMode SelectionMode { get; set; }

Property Value

Type: Microsoft.Office.Interop.Excel.XlPTSelectionMode

Remarks

If the PivotTable field isn’t in outline form, specifying the sum of any of the constants and xlFirstRow is equivalent to specifying the constant alone.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace