RecordCount Property Example

This example displays the number of cache records that contain "Kiwi" in the "Products" field.

MsgBox Worksheets(1).PivotTables("Pivot1") _
    .PivotFields("Product").PivotItems("Kiwi").RecordCount