Purpose
Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).
Syntax
SheetPivotTableAfterValueChange(Sh, TargetPivotTable, TargetRange)
Required Parameters
Sh
The worksheet that contains the PivotTable
TargetPivotTable
The PivotTable that contains the edited or recalculated cells.
TargetRange
The range that contains all the edited or recalcuated cells.