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