Reference an inserted picture by location without looping

**bdb1974** · 07-19-2012, 05:23 PM

Hi all,

Anyone know if i can make reference to an inserted picture by its location without performing a loop through all shapes first and not knowing the pictures name specifically?

Currently I'm using:

Please Login or Register  to view this content.

Any help is appreciated.

Thanks,

BDB

**Leith Ross** · 07-19-2012, 10:13 PM

Hello BDB,

Without a name, you can not locate the object without looping. The worksheet is the parent object that contains the picture and sets the left, top, height, and width properties when it is added to the worksheet but the worksheet does create a collection of the picture objects by their location, only by name.

**Andy Pope** · 07-20-2012, 03:51 AM

As Leith says there is a picture collection you can loop through. You can also use the TopLeftCell property to determine whether the picture is located near the area.

Please Login or Register  to view this content.

**bdb1974** · 07-24-2012, 09:50 AM

Looping through just the pictures appears to be a better solution than looping through all the sheets objects.
I do have a couple issues/concerns remaining. First, how do I reference or select the obj pic for deletion?
I have tried the following statements and none work.

Please Login or Register  to view this content.

Second may not be an issue/concern using the Intersect method, but previously I had situation where a picture I would attemp to remove would slightly be overlapping another cell. So testing whether the selected cell top matched the picture top would fail. Can this be the case for
using the interest method too?

Please Login or Register  to view this content.

Any feedback is welcome.

Thanks guys.

BDB

**Andy Pope** · 07-24-2012, 11:21 AM

Please Login or Register  to view this content.

If your pictures are not positioned correctly then you will need to come up with a more broader criteria and test that. The picture has a topleftcell and a bottomrightcell whic you can use, including resizing that range to extend outwards.

**bdb1974** · 07-24-2012, 12:19 PM

Thanks Andy for responding back.
I don't think this picture position is going to be an issue after all.
I managed to delete the picture by dimming the objPic as Object (which I had initially did not do), objPic.select, objPic.cut

However the last code you posted looks interesting. I may use it if I come across any other issues that have not yet been present.

I believe this pretty much resolves my problems. Therefore, I'm closing this thread.

Thanks again Andy for you help.

Regards,

BDB