Application SheetPivotTableAfterValueChange Event

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.