Display an image that is referenced by a hyperlink

[stefanaalten]

How can I display an image that is referenced in a different worksheet?

For example, sheet1!A1 contains a link to an image file, just a hyperlink to a local jpg. On sheet2, in some arbitrary cell, say B5, I would like to display the image that is referenced in sheet1!A1, i.e. sheet2!B5 shows the actual image that is referred to as a link in sheet1!A1.

Many thanks for any help!

PS This is a much cut-down version of my other question, posted on this forum, but the other question involves the entire problem I'm trying to solve, not just the image reference thing I'm asking for here so it's not a cross-post/double post! Thanks.

 

[John_w]

Sub Show_Image()
    With Sheet2
        .Range("B5").Select
        .Pictures.Insert Sheet1.Range("A1").Value
    End With
End Sub