PivotLine Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

A PivotLine object is a line of rows or columns in an Excel PivotTable.

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.

Creator

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

LineType

Returns an XlPivotLineType constant that indicates the type of PivotLine. Read-only.

Parent

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

PivotLineCells

Returns a collection of PivotCell objects in a PivotLine. Read-only.

PivotLineCellsFull

Retrieves all of the PivotLine cells including those that are hidden in compact form. Read-only

Position

Returns or sets the position of the PivotLine object. Read-only.

Show: