Share via

TableStyle Property [Excel 2003 VBA Language Reference]

  • Article

Returns or sets the style used in the body of the PivotTable report. The default value is a null string (no style is applied by default). Read/write String.

Remarks

This style is used as the default style for the background area, and it's applied before any user formatting.

Example

This example sets the body of the PivotTable report to the PurpleAndGold style.

Worksheets(1).PivotTables("Pivot1").TableStyle = "PurpleAndGold"

Applies to | PivotTable Object