Class PivotAxis (Excel VBA)

The PivotAxis object is used for asymmetric drilling in a PivotTable.

Item

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

Dim pas as PivotAxis
Set pas = ActiveCell.PivotTable.PivotColumnAxis

The following procedures can be used to set variables of type PivotAxis: PivotTable.PivotColumnAxis and PivotTable.PivotRowAxis.

PivotLines

Returns the PivotLines object attached to the specified PivotAxis object.

Dim plsPivotLines As PivotLines
Set plsPivotLines = ActiveCell.PivotTable.PivotColumnAxis.PivotLines