How to Determine Index Number of New Shape

Hi everyone,

*Note: I am accessing the Excel Library from a different program, so the "dim" and "set" lines are a little different*

I'd like to know how to determine the index number of a new shape, specifically the picture I just pasted into a certain cell. I want to resize it. I know if it is the first picture in a blank sheet, I can just do this:

Please Login or Register  to view this content.

But what if there are already some number of shapes in the worksheet already? How do I know what to put instead of 1? Is there a command that can tell me the index number of the last shape?

Thanks!

You don't necessarily need to know the index number:

Please Login or Register  to view this content.

Excellent. Thanks!