Copy Shapes between Worksheets

Copying a Picture from one Worksheet to Another

To copy a picture from one worksheet to another, use the Worksheet.Pictures.Add method as shown in the sample code below.

Copy a Chart from one Worksheet to Another

The following code demonstrates the use of Worksheet.Shapes.AddCopy method to copy a chart from one worksheet to another.

Copy Controls and Other Drawing Objects from One Worksheet to Another

To copy controls and other drawing objects, use the Worksheet.Shapes.AddCopy method as shown in the example below.