PivotTable.PivotSelectionStandard Property

Syntax

expression.PivotSelectionStandard

expression A variable that represents a PivotTable object.

Remarks

The PivotSelectionStandard property is "international-friendly" whereas the PivotSelection method is not.

Example

This example selects a field titled "1.57" in the PivotTable and inserts a blank column field before it. The example assumes a PivotTable exists on the active worksheet that contains a column field titled "1.57".

Sub CheckPivotSelectionStandard() Dim pvtTable As PivotTable Set pvtTable = ActiveSheet.PivotTables(1) pvtTable.PivotSelectionStandard = "1.57" Selection.Insert End Sub

See also:

• PivotTable Object
• PivotTable Object Members