PivotCell.RowItems property (Excel)

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 that a PivotTable exists on the active worksheet, and that column B of the worksheet contains a row item of the PivotTable.

Sub CheckRowItems() 
 
 ' Determine if there is a match between the item and row field. 
 If Application.Range("B5").PivotCell.RowItems.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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.