PivotSelectionStandard Property

Microsoft Excel Visual Basic

expression.PivotSelectionStandard

expression    Required. An expression that returns 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