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)

Syntax

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00024458-0000-0000-C000-000000000046")> _
Public Interface PivotCell
'Usage
Dim instance As PivotCell
[InterfaceTypeAttribute()]
[GuidAttribute("00024458-0000-0000-C000-000000000046")]
public interface PivotCell

Remarks

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.

See Also

Reference

PivotCell Members

Microsoft.Office.Interop.Excel Namespace