PivotField.AutoShowRange Property

Syntax

expression.AutoShowRange

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

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`

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 range Auto Show Range Property AutoShowRange AutoShowRange Property Find out if pivottable autoshow items start at the top or bottom? Read start location for autoshow items?

Returns xlTop if the top items are shown automatically in the specified PivotTable field; returns xlBottom if the bottom items are shown. Read-only Long.

See also: