IDocEvents.PivotTableBeforeAllocateChanges Method

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

Syntax

'Declaration
Sub PivotTableBeforeAllocateChanges ( _
    TargetPivotTable As PivotTable, _
    ValueChangeStart As Integer, _
    ValueChangeEnd As Integer, _
    <OutAttribute> ByRef Cancel As Boolean _
)
'Usage
Dim instance As IDocEvents
Dim TargetPivotTable As PivotTable
Dim ValueChangeStart As Integer
Dim ValueChangeEnd As Integer
Dim Cancel As Boolean

instance.PivotTableBeforeAllocateChanges(TargetPivotTable, _
    ValueChangeStart, ValueChangeEnd, _
    Cancel)

void PivotTableBeforeAllocateChanges(
    PivotTable TargetPivotTable,
    int ValueChangeStart,
    int ValueChangeEnd,
    out bool Cancel
)

Parameters

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

• ValueChangeStart
  Type: System.Int32

• ValueChangeEnd
  Type: System.Int32

• Cancel
  Type: System.Boolean

See Also

Reference

IDocEvents Interface

IDocEvents Members

Microsoft.Office.Interop.Excel Namespace