Excel 2007 : test if picture exists on sheet

[JimBobBowie]

Hi All,

I am working on a project and have a named picture on a sheet that gets replaced when the user changes the product viewed. If the picture gets deleted manually by the user or the previous product did not have an image the macro falls over when the clear old picture section in reached. I need to test for the existance of the old picture on the sheet to determine if I need to run the clear/delete existing picture before inserting the new one. Any ideas would help alot

Thanks

[StuCram]

Hi Jim

Here is the code I've used in a project with a similar goal.
It checks all images on the sheet and deletes only the one(s) with the specified name 'Meet_Logo' in my example below.

Please Login or Register  to view this content.

Hope this helps a bit.
- Stu

[shg]

Another way:

Please Login or Register  to view this content.

... or

Please Login or Register  to view this content.