PivotLines Members (Excel)

  • Article

The PivotLines object is a collection of lines in a PivotTable, containing all lines on rows or columns of the pivot. Each line is a set of PivotCells.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

Count

Returns the number of items in the PivotLines collection. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Item

Returns a specific element of the PivotLines collection object by its position in the collection. Read-only.

Parent

Returns the parent object for the specified PivotLines object. Read-only.