PivotItem Property

Applies To

Range object.

Description

Returns a PivotItem object that represents the pivot item containing the upper-left corner of the specified range. Read-only.

Example

This example displays the name of the pivot item that contains the active cell on Sheet1.

Worksheets("Sheet1").Activate
MsgBox "The active cell is in the item " & _
    ActiveCell.PivotItem.Name