Class PivotLineCells (Excel VBA)

Collection of PivotCell objects for a specific PivotLine. To use a PivotLineCells class variable it first needs to be instantiated, for example

Dim plcs as PivotLineCells
Set plcs = ActiveCell.PivotCell.PivotColumnLine.PivotLineCellsFull

For Each

Here is an example of processing the PivotLineCells items in a collection.

Dim pvtlcelPivotLineCell As PivotCell
For Each pvtlcelPivotLineCell In Application.PivotLineCells
	
Next pvtlcelPivotLineCell

Count

Returns the number of items in the PivotLineCells collection.

Dim lngCount As Long
lngCount = ActiveCell.PivotCell.PivotColumnLine.PivotLineCellsFull.Count

Full

When True, all of the PivotLineCells in the PivotLine (including those that are hidden in compact form) are retrieved.

Dim booFull As Boolean
booFull = ActiveCell.PivotCell.PivotColumnLine.PivotLineCellsFull.Full

Item

Returns a specific element of the PivotLineCells collection object by its position in the collection.

Item (Index)

Index: Specifies the position of an element of the collection.

Dim pvtlcelItem As PivotCell
Set pvtlcelItem = ActiveCell.PivotCell.PivotColumnLine.PivotLineCellsFull(Index:=1)