VBA hyperlink using VLOOKUP

[GedSalter]

I have a worksheet called "Sum" In cell B10 there is text which changes. I want a VBA hyperlink which will goto another worksheet called "Definitions" where the text will be in a named range called "Definition"

I have no clue how to do this and I have been searching for ages.

 

[Saba Sabaratnam]

You could use HYPERLINK formula to attain this.


=HYPERLINK(" #"&B10)

Kind regards

Saba

 

[GedSalter]

I tried it in a VBA. Doesnt work.

 

[GedSalter]

the named range in ws Definitions is called "definition" range A1:A150. In cell B10 in 'Sum ws is a word which is in a drop down list of around 50 names. This word need to hyperlink to relevant cell in the definition range.

hope this helps