VacatedStyle Property Example
This example sets the vacated cells in the PivotTable report to the BlackAndBlue style.
Worksheets(1).PivotTables("Pivot1").VacatedStyle = "BlackAndBlue"