Excel.PivotTable.VacatedStyle.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.VacatedStyle property (Excel)	vbaxl10.chm235129	vbaxl10.chm235129	Excel.PivotTable.VacatedStyle	94be037f-3fce-ad39-9dd6-b72f829c3fbf	05/09/2019	medium

PivotTable.VacatedStyle property (Excel)

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.

Worksheets(1).PivotTables("Pivot1").VacatedStyle = "BlackAndBlue"

[!includeSupport and feedback]