Syntax
expression.AutoShowCount
expression A variable that represents a PivotField object.
Example
This example displays a message box showing the AutoShow parameters for the Salesman field.
| Visual Basic for Applications
|
With Worksheets(1).PivotTables(1).PivotFields("salesman") If .AutoShowType = xlAutomatic Then r = .AutoShowRange If r = xlTop Then rn = "top" Else rn = "bottom" End If MsgBox "PivotTable report is showing " & rn & " " & _ .AutoShowCount & " items in " & .Name & _ " field by " & .AutoShowField Else MsgBox "PivotTable report is not using AutoShow for this field" End If End With
|
auto show count Auto Show Count Property AutoShow AutoShowCount AutoShowCount Property Number of autoshow items visible? Return count of items showing in the autoshow field?
See also: