Hi There,

Very new to all this and first ever forum post so take it easy on me if this is not in the right location or explained perfectly etc.

I am trying to create a macro that is linked to a picture. When the picture is clicked I need it to reference a cell in excel and follow the hyperlink. This hyperlink changes based on a vlookup formula.

For Example

In Sheet1 I have a drop down menu located in cell B9 (Cell name =SelectedNewCar), based on what is selected the formula in cell A27 looks up a hyperlink in a table in sheet2 (The table range is= NewCarDetails) the formula is =HYPERLINK(VLOOKUP(SelectedNewCar,NewCarDetails,10,FALSE))

I have tried creating a macro with the following:-

Range("A27").Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

I have tried a few variations on this but gett runtime error 9 or I get a subscription out of range error.

I have trawled through various posts online but can't seem to find a suitable solution.

Is anyone able to assist in this area?

Thank You