Class PivotValueCell (Excel VBA)

Provides a way to expose values of cells in the case that actual cells (Range objects) are not available.

Item

To use a PivotValueCell class variable it first needs to be instantiated, for example

Dim pvc as PivotValueCell
Set pvc = ActiveCell.PivotTable.PivotValueCell()

PivotValueCell class variables can be set using the PivotTable.PivotValueCell procedure.

PivotCell

Returns the PivotCell object that specifies the location of the PivotValueCell.

Dim pvtlcelPivotCell As PivotCell
Set pvtlcelPivotCell = ActiveCell.PivotTable.PivotValueCell.PivotCell

ServerActions

Returns a collection of OLAP Action name objects that represent OLAP-defined actions that can be executed.

A server action is an optional feature that an OLAP cube administrator can define on a server that uses a cube member or measure as a parameter into a query to obtain details in the cube, or to start another application.

Dim actsServerActions As Actions
Set actsServerActions = ActiveCell.PivotTable.PivotValueCell.ServerActions

ShowDetail

Puts the individual rows of an OLAP data source that contribute to an aggregate onto their own Excel worksheet.

ActiveCell.PivotTable.PivotValueCell.ShowDetail

Value

Returns the value at the location. The value is the value after ShowAs and other calculations have been applied. Variant can be Empty, Number, Date, String, or Error value.

This property works independently of whether the PivotTable is on a worksheet or not.

Dim varValue As Variant
varValue = ActiveCell.PivotTable.PivotValueCell.Value