PivotTable.PivotSelect(String, XlPTSelectionMode, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Selects part of a PivotTable report.

public void PivotSelect (string Name, Microsoft.Office.Interop.Excel.XlPTSelectionMode Mode = Microsoft.Office.Interop.Excel.XlPTSelectionMode.xlDataAndLabel, object UseStandardName);

Public Sub PivotSelect (Name As String, Optional Mode As XlPTSelectionMode = Microsoft.Office.Interop.Excel.XlPTSelectionMode.xlDataAndLabel, Optional UseStandardName As Object)

Parameters

Name: String

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

Mode: XlPTSelectionMode

Optional XlPTSelectionMode. Specifies the structured selection mode.

UseStandardName: 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.

Applies to