Remove extra drawing objects

[A_Pitts]

When the print macro is run, I copy and paste 3 different logos into my form based on the product class that is accepted. This works until the user changes his mind about the class. The original drawing object is still there.
Since they always paste to the same location, I'd like to make the first step be to just remove whichever one is there so that the new one can be pasted.

Here's what I'm doing:

If Range("I5").Value = "Product A" Then
ActiveSheet.Shapes("Picture 27").Select
Selection.Copy
Range("A1").Select
ActiveSheet.Paste
Range("A1:J52").Select
Selection.PrintOut Copies:=1, Preview:=True, Collate:=True
Range("F7").Select

Any thoughts.
Thanks,
A_Pitts

 

[A_Pitts]

I've tried a lot of different ways, but Excel gives the drawing object a different picture number each time it pastes. And without the correct number or a way to remove all the objects from the paste area, I'm stumped.

Thanks,
A_Pitts

 

[Ivan F Moala]

Basically, Name your Pictures via the namebox.
Activate & Copy your Pictures via these names.
Delete All othe Pictures that are not thes names via a select case statement.

Post back if help required..

 

[A_Pitts]

Thanks for the response.

I searched the help file and didn't find "namebox", how to use it, etc. The only thing I seem to be able to do is right click the object and rename the macro associated with it (There are none).
Also, could you post a small example of "Delete All of the Pictures that are not these names via a select case statement." I only have a dozen or so buttons to exclude so that should be doable. If it only references a specific location on the sheet, would I only have to include the names of the logos that I might paste there.
It's late here, so I'll check tomorrow.

Thanks,
A_Pitts

 

[Ivan F Moala]

<SCRIPT language=JavaScript src="http://www.xcelfiles.com/popup.js"></SCRIPT>

Book1
	A	B	C	D
1	<<NameBox
2
3
4
Sheet1

As for Code ... let me get some examples ... latter