PivotTable.PivotSelect Method (Excel)

Office 2010

Selects part of a PivotTable report.

.PivotSelect(Name, Mode, UseStandardName)

A variable that represents a PivotTable object.

Parameters

Name

Required/Optional

Data Type

Description

Name

필수

String

The part of the PivotTable report to select.

Mode

선택

XlPTSelectionMode

Specifies the structured selection mode.

UseStandardName

선택

Variant

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

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.

This example selects all date labels in the first PivotTable report on worksheet one.

Worksheets(1).PivotTables(1).PivotSelect "date[All]", xlLabelOnly
표시: