deleting picture (shape)

Hello Gurus,

The user of this spreadsheet inserts data and pastes a picture in the a specific place. Example cell AJ4

Sometimes the user copies the spreadsheet and deletes the picture and adds another.

I am looking to create a macro that deletes the picture automatically (and perform some other functions).

Below is the recorded code for deleting that picture in the spreadsheet. However, the name "Picture 2" is constantly changing, therefore the code cannot specifically say "picture 2"

Please Login or Register  to view this content.

How do I get around this?

TIA,
Tim

Is there only one picture? If so, would a quick for/each work?

Please Login or Register  to view this content.

No there are a total of 3. I am looking to delete one in a particular location cell AJ4.

I figured it out.

Due to the complexity of this spread sheet, I eliminated some details when I posted the original question.

Solution in a nutshell:
When the picture is placed, I rename it to "Picture X". When running the macro, "Picture X" is deleted and a new picture is placed and renamed "Picture X". This was the only way I could keep the name the same.

Tim