Finding image location in Excel

Question

Say if I have an Excel spreadsheet with an overlay image. Obviously, they are not embedded in any cell and are instead placed on top of the spreadsheet.

How can I find the cells where the image is located? Is there any way to do this?

Answer 1

You can view the collection Shapeson your sheet. You still need to figure out which one is interesting, if there are a lot of them. In VBA, you can start with something like:

Sub Macro1()

    Dim o As Shape

    For Each o In Sheet1.Shapes
        Debug.Print o.Name, o.TopLeftCell.Address, o.BottomRightCell.Address
    Next

End Sub