Hi All,

I have inherited a worksheet containing hundreds of images roughly fit to cells that correspond to consecutive reference code running down column A - The references run REF1, REF2, REF3, REF4, etc down column A. The pictures were added after the sheet was created and were not added in consecutive order down the sheet - e.g. REF1 corresponds to Picture5 and REF2 corresponds to Picture115.

What I would like to achieve is the programmatic renaming of each picture as it's corresponding reference code while at the same time saving each renamed picture to a single folder at a specific file path/location.

I thought that because each picture is in line (in the same row) as its true reference code, that maybe this could be achieved by renaming each picture based on its position from the top of the worksheet. The picture with the smallest top alignment would be renamed to REF1 and saved to X location. The picture with the next smallest top alignment would be renamed to the next reference code REF2 and saved to X location, etc.

I am clutching at straws here as I have no idea if any of this is possible and I have spent many of hours looking for a solution. I'm also hoping this is a clear enough description!

If any one could assist it would be greatly appreciated.

Many thanks,