PivotColumnMember Object

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.


Aa198594.parchild(en-us,office.10).gifPivotColumnMember
Aa198594.space(en-us,office.10).gifAa198594.parchild(en-us,office.10).gif

Represents the values displayed for a grouped field in the column area of a PivotTable list. The PivotColumnMember object is a member of the PivotColumnMembers collection.

Using the PivotColumnMember object

The following properties return a PivotColumnMember object:

The PivotCell object's ColumnMember property

The PivotResultColumnAxis object's ColumnMember property

The PivotColumnMember object's FindColumnMember property

The PivotColumnMember object's ParentColumnMember property

The PivotColumnMember object's TotalColumnMember property

The PivotColumnMembers collection's **Item**property

The PivotData object's **Left**property

The PivotColumnMember object has many properties in common with the PivotAxisMember object. Use the DetailLeft, DetailLeftOffset, **DetailsExpanded**properties or MoveDetailLeft method to customize the way detail records are displayed.