PivotTable.TableStyle2 Property

  • Article
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