Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotCell interface

Represents a cell in a PivotTable report.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[InterfaceTypeAttribute()]
[GuidAttribute("00024458-0000-0000-C000-000000000046")]
public interface PivotCell

Use the PivotCell property of the Range collection to return a PivotCell object.

Once a PivotCell object is returned, you can use the PivotCellType property to determine what type of cell a particular range is.

You can use the ColumnItems or RowItems property to determine the PivotItems collection that corresponds to the items on the column or row axis that represents the selected number.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft