PivotTable.VacatedStyle (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).

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