|Excel Developer Reference|
expression A variable that represents a Range object.
This example determines the name of the PivotTable the PivotCell object is located in and notifies the user. The example assumes that a PivotTable exists on the active worksheet and that cell A3 is located in the PivotTable.
|Visual Basic for Applications|