WorkbookEvents.SheetPivotTableBeforeAllocateChanges Method

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub SheetPivotTableBeforeAllocateChanges ( _
    Sh As Object, _
    TargetPivotTable As PivotTable, _
    ValueChangeStart As Integer, _
    ValueChangeEnd As Integer, _
    <OutAttribute> ByRef Cancel As Boolean _
)
'Usage
Dim instance As WorkbookEvents
Dim Sh As Object
Dim TargetPivotTable As PivotTable
Dim ValueChangeStart As Integer
Dim ValueChangeEnd As Integer
Dim Cancel As Boolean

instance.SheetPivotTableBeforeAllocateChanges(Sh, _
    TargetPivotTable, ValueChangeStart, _
    ValueChangeEnd, Cancel)

void SheetPivotTableBeforeAllocateChanges(
    Object Sh,
    PivotTable TargetPivotTable,
    int ValueChangeStart,
    int ValueChangeEnd,
    out bool Cancel
)

Parameters

• Sh
  Type: System.Object

• TargetPivotTable
  Type: Microsoft.Office.Interop.Excel.PivotTable

• ValueChangeStart
  Type: System.Int32

• ValueChangeEnd
  Type: System.Int32

• Cancel
  Type: System.Boolean

See Also

Reference

WorkbookEvents Interface

WorkbookEvents Members

Microsoft.Office.Interop.Excel Namespace