PivotTable.PivotSelect Method

Selects part of a PivotTable report.

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

Syntax

'Declaration
Sub PivotSelect ( _
    Name As String, _
    Mode As XlPTSelectionMode, _
    UseStandardName As Object _
)
'Usage
Dim instance As PivotTable
Dim Name As String
Dim Mode As XlPTSelectionMode
Dim UseStandardName As Object

instance.PivotSelect(Name, Mode, UseStandardName)

void PivotSelect(
    string Name,
    XlPTSelectionMode Mode,
    Object UseStandardName
)

Parameters

• Name
  Type: System.String

  Required String. The selection, in standard PivotTable report selection format.

• Mode
  Type: Microsoft.Office.Interop.Excel.XlPTSelectionMode

  Optional XlPTSelectionMode. Specifies the structured selection mode.

• UseStandardName
  Type: System.Object

  Optional Object. True for recorded macros that will play back in other locales.

Remarks

You can use the specified mode only to select the corresponding item in the PivotTable report. For example, you cannot select data and labels by using xlButton mode; likewise, you cannot select buttons by using xlDataOnly mode.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace