WorkbookEvents.SheetPivotTableAfterValueChange Method
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub SheetPivotTableAfterValueChange ( _
Sh As Object, _
TargetPivotTable As PivotTable, _
TargetRange As Range _
)
'Usage
Dim instance As WorkbookEvents
Dim Sh As Object
Dim TargetPivotTable As PivotTable
Dim TargetRange As Range
instance.SheetPivotTableAfterValueChange(Sh, _
TargetPivotTable, TargetRange)
void SheetPivotTableAfterValueChange(
Object Sh,
PivotTable TargetPivotTable,
Range TargetRange
)
Parameters
- Sh
Type: System.Object
- TargetPivotTable
Type: Microsoft.Office.Interop.Excel.PivotTable
- TargetRange
Type: Microsoft.Office.Interop.Excel.Range