PivotTable.TableStyle2 Property

Version Information
Version Added: Excel

Syntax

expression.TableStyle2

expression A variable that represents a PivotTable object.

Remarks

The property is called TableStyle2 because there is an exisiting property named TableStyle.

Example

Visual Basic for Applications
`Sub ApplyingStyle() ActiveSheet.PivotTables("PivotTable1").TableStyle2 = "PivotStyleLight17" End Sub`

The TableStyle2 property specifies the PivotTable style currently applied to the PivotTable. Read/write.