Purpose
Occurs before changes to a PivotTable are discarded.
Syntax
SheetPivotTableBeforeDiscardChanges(Sh, TargetPivotTable, ValueChangeStart, ValueChangeEnd)
Required Parameters
Sh
The sheet object.
TargetPivotTable
The PivotTable that contains the changes to discard.
ValueChangeStart
The index to the first change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.
ValueChangeEnd
The index to the last change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.
