Excel.PivotTable.TableStyle2.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.TableStyle2 property (Excel)	vbaxl10.chm235171	vbaxl10.chm235171	Excel.PivotTable.TableStyle2	d2d79fc6-2ead-91a9-f304-92248584f4b2	05/09/2019	medium

PivotTable.TableStyle2 property (Excel)

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

Syntax

expression.TableStyle2

expression A variable that represents a PivotTable object.

Remarks

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

Example

Sub ApplyingStyle() 
 
 ActiveSheet.PivotTables("PivotTable1").TableStyle2 = "PivotStyleLight17" 
 
End Sub

[!includeSupport and feedback]