Applies To
Range Object.
Description
Accessor. Returns a PivotItem object that represents the pivot item containing the top left corner of the specified range. Read-only.
Example
This example displays the name of the pivot item containing the active cell.
Worksheets("Sheet1").Activate MsgBox "The active cell is in the item " & _ ActiveCell.PivotItem.Name