Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotTable.TableStyle2 Property

Office 2007
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




Community Additions

Show:
© 2014 Microsoft