Export (0) Print
Expand All
Expand Minimize
0 out of 2 rated this helpful - Rate this topic

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

ADD
Show:
© 2014 Microsoft. All rights reserved.