Referencing a piece of clipart in a cell

[nigelandrewfoster]

Hi, I want to be able to refer to clipart according to the cell it is found in. Can this be done, please?

 

[RoryA]

Not as such, no. You have to loop through the shapes and check the TopLeftCell property, unless you use a naming convention that includes the cell address.

 

[nigelandrewfoster]

Thanks. Guess I'll just give them numbers for names.