PivotTable.VacatedStyle Property

  • Article
Excel Developer Reference

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.

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"

See Also