PivotCell.RowItems property (Excel)
Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell.
expression A variable that represents a PivotCell object.
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.