Delete single picture from sheet and leave others

[danny25]

Hi all
I have several pictures on my sheet one being the header the other inserts into J6
When D2 has specific text a corresponding picture appears in J6, As D2 changes the picture is deleted and a new picture inserted into J6
The code below deletes all pictures from the sheet than updates J6 including the header
I want the header picture to stay always
i have tried many different things but still deletes all
Any help is greatly appreciated

Please Login or Register  to view this content.

[davesexcel]

If your picture is in A1 then you loop through the pictures and delete the pictures that are not in A1

Please Login or Register  to view this content.

[danny25]

Thanks worked like a charm