How do you get the 'name' of an image inserted into a cell?

Hello fatkatie,

Okay, a short lesson on system object collections and yes there will be a test afterwards. Excel organizes objects using Collections, which are also objects. The Collection uses "key" and "item" pairs. The key can be a string name like "Picture 2" or and numeric index like 1. The Collection will retrieve the "item" associated with key or throw an error. Each Item in the collection can just about anything: an array, number, string, date, or an object.

Each worksheet has a collection called "Pictures" that keeps track of Pictures belonging to the worksheet. When a Picture is added, the Collection creates a default name based on the object and a counter index value. This where the "Picture 2" comes from. You can of course change this name if you like. Either using the Name Box dropdown or through code.

Please Login or Register  to view this content.

Now that you assigned it to an Object variable, you can do what you like with it.

To continue on Marc L 's suggestion here a piece of code which deletes the picture recorded in the range WkRg
You may use it the rename it or just to know what it is .

Please Login or Register  to view this content.