PivotItem.RecordCount Property

Syntax

expression.RecordCount

expression A variable that represents a PivotItem object.

Remarks

This property reflects the transient state of the cache at the time that it's queried. The cache can change between queries.

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

See also:

• PivotItem Object
• PivotItem Object Members