Class PivotAxis (Excel VBA)

The PivotAxis object is used for asymmetric drilling in a PivotTable. To use a PivotAxis class variable it first needs to be instantiated, for example

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

PivotLines

Returns the PivotLines object attached to the specified PivotAxis object.

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