PivotTable.VacatedStyle Property

Syntax

expression.VacatedStyle

expression A variable that represents a PivotTable object.

Example

This example sets the vacated cells in the PivotTable report to the BlackAndBlue style.

Visual Basic for Applications
`Worksheets(1).PivotTables("Pivot1").VacatedStyle = "BlackAndBlue"`

change style vacated cells pivot table return vacated style of pivot tables set style cells vacated pivot table refreshed vacated vacated style Vacated Style Property VacatedStyle vacatedstyle property

Returns or sets the style applied to cells vacated when the PivotTable report is refreshed. The default value is a null string (no style is applied by default). Read/write String.

See also: