Checking a cell for an image there and if present, deleting it

I am using Excel 2007.

Hello. I've come here after several days of googling and searching these forums, ozgrid and stackoverflow. I've found a few examples of something close to what I'm looking to do, but it's not quite there or I'm just not implementing it correctly. I'm extremely new to using macros in Excel and have been learning all I can the past few weeks, but I ask any explanations please be given to me like I'm 8

What I'm trying to accomplish is thus: I have a button that depending on a few drop down selections, will copy an image from another worksheet and paste it into the "Main" worksheet at B15. Before that occurs, I'd like the button to first check that cell (B15) for an existing image and delete it without removing any other images on the worksheet.

If anyone could guide me on how to do this (remembering I'm still very new to this) I would greatly appreciate it.

Thank you very much! That worked! I think where I had gone grievously wrong was in assuming I should be going after .Shapes this entire time. I had code almost identical to what you were running there, but swap .Pictures for .Shapes. I switched everything around in what I had to reflect the change to .Pictures and it works perfectly. Seriously can't thank you enough!

Actually, I had a couple questions so that hopefully I can learn more from this.

Why when I had everything as shapes, did it not work? I tried the following but it gives a run-time error '1004': Application-defined or object-defined error. This is when I was copy/pasting the image over as a .Shape rather than .Picture.

Please Login or Register  to view this content.

Also, I think I have been using .Address incorrecty... You put (0,0) after yours - what does that do? I thought .Address just brought back the cell of whatever you tagged that on to.

Thanks again for all the help!