Shape.Duplicate Method (Excel)

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

expression .Duplicate

expression A variable that represents a Shape object.

Return Value

Shape

This example duplicates embedded chart one on Sheet1 and then selects the copy.

Set dChart = Worksheets("Sheet1").ChartObjects(1).Duplicate 
dChart.Select

Concepts

Other resources

Show:
© 2015 Microsoft