Share via


PivotTable.TableStyle2 Property

Excel Developer Reference

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

Version Information
 Version Added:  Excel 2007

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

See Also