RecordCount Property
Applies To
PivotCache object, PivotItem object.
Description
Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item. Read-only Long.
Example
This example displays the number of cache records that contain "Kiwi" in the "Product" field.
MsgBox Worksheets(1).PivotTables("Pivot1") _
.PivotFields("Product").PivotItems("Kiwi").RecordCount