Get path of in cell picture

[mikeymay]

I have a picture in a cell that is added using Insert, Pictures, Place in cell.

When the cell that contains the picture is selected, it shows the file path/location of the picture.

Is there a way of returning this file path/location?

When the cell is referenced in some code, it errors as the request to get the location

strPath = Range("Image")

is actually Error 2015.


TIA

 

[mikeymay]

Solved -

When the picture is inserted into the file, you have to select the image file.

This stores the file path as a string so I have dropped that into the file and refer back to it to get the file path.