Note that if you Insert all pictures on a Worksheet then you can name each one and refer to it by Name when copying to to another sheet or UserFormSub deleteallShapes() Shapes.SelectAll Selection.Delete End Sub
Dim Pieces As Object Set Pieces = Sheets("Sheet1").Shapes 'Worksheet2 'Insert 'Pieces("ABC")