Syntax
Private Sub Worksheet_PivotTableAfterValueChange(ByVal TargetPivotTable As PivotTable, ByVal TargetRange As Range)
Enter
Code
End Sub
This event occurs after a cell or range of
cells inside a PivotTable are edited or recalculated (for cells that contain
formulas).
Required Parameters
TargetPivotTable
The PivotTable that contains the edited or
recalculated cells.
TargetRange
The range that contains all the edited or
recalcuated cells.
