Excel.TableStyle.Duplicate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
TableStyle.Duplicate method (Excel)	vbaxl10.chm839081	vbaxl10.chm839081	Excel.TableStyle.Duplicate	60f807ff-2f4f-137d-54d7-37b168dbc8c7	05/17/2019	medium

TableStyle.Duplicate method (Excel)

Duplicates the TableStyle object and returns a reference to the new copy.

Syntax

expression.Duplicate (NewTableStyleName)

expression A variable that represents a TableStyle object.

Parameters

Name	Required/Optional	Data type	Description
NewTableStyleName	Optional	Variant	The name of the new table style.

Return value

TableStyle

Remarks

If no name is specified, the Duplicate method uses the same default name as the user interface.

[!includeSupport and feedback]