Class Actions (Excel VBA)

A collection of all Action objects for the specified series. To use a Actions class variable it first needs to be instantiated, for example

Dim acts as Actions
Set acts = ActiveCell.PivotTable.PivotValueCell.ServerActions

Count

Returns the number of objects in the collection.

Dim lngCount As Long
lngCount = ActiveCell.PivotTable.PivotValueCell.ServerActions.Count

Item

Returns an Actions object that represents a collection of actions in a workbook.

Item (Index)

Index: Index value of the action.

Dim actItem As Action
Set actItem = ActiveCell.PivotTable.PivotValueCell.ServerActions(Index:=1)