Automate Hyperlinks to Pictures

Hi Nick

Welcome to the Forum.

If you've not resolved this issue perhaps I can help. I've developed some workbooks that include images.

I'd like to see an "actual" representation of your workbook that includes the worksheet where the hyperlink is to be inserted and that demonstrates this

I have a large Excel spreadsheet in which column I lists one picture number for each row. This number is the exact name of the picture (but without the .jpg extension).

I'd also like to see your Directory Tree that demonstrates this (the actual Tree isn't important...I'd like to see the structure)

The pictures are located in a folder which resides in the same directory and at the same level as the spreadsheet.

Pictures aren't important...I've plenty of those that I'll copy and rename.

Perhaps I can help...perhaps not.