XlPTSelectionMode Enumeration 

Specifies what may be selected in a PivotTable during a structured selection. These constants may be combined to select multiple types.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Usage

Dim xlPTSelectionMode1 As XlPTSelectionMode = XlPTSelectionMode.xlBlanks

Syntax

Public Enum XlPTSelectionMode
public enum XlPTSelectionMode
public enum class XlPTSelectionMode
public enum XlPTSelectionMode
public enum XlPTSelectionMode

Members

Member name Description
xlBlanks Blanks.
xlButton Buttons.
xlDataAndLabel Data and labels.
xlDataOnly Data.
xlFirstRow First row.
xlLabelOnly Label.
xlOrigin Origin.

Platforms

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

See Also

Reference

Microsoft.Office.Interop.Excel Namespace