Share via

PivotCell.RowItems Property

  • Article
Excel Developer Reference

Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell.

Syntax

expression.RowItems

expression   A variable that represents a PivotCell object.

Example

This example determines if the data item in cell B5 is under the Inventory item in the first row field and notifies the user. The example assumes a PivotTable exists on the active worksheet and that column B of the worksheet contains a row item of the PivotTable.

Visual Basic for Applications 
  Sub CheckRowItems()

' Determine if there is a match between the item and row field.
If Application.Range("B5").PivotCell.<strong class="bterm">RowItems</strong>.Item(1) = "Inventory" Then
    MsgBox "Cell B5 is a member of the 'Inventory' row field.
Else
    MsgBox "Cell B5 is not a member of the 'Inventory' row field.
End If



End Sub

See Also