How to display macro result (cell ref) as hyperlink

Hi,

I am relatively new to macros - and have what is probably a fairly simple problem. I have found a macro that searches several sheets for a specific value (entered in Sheet2 cell D10), then displays a list of cell references containing that value. I need each cell reference to be a hyperlink so the user can click and go straight to that sheet/cell.

Please Login or Register  to view this content.

I've spent all morning messing with the code via trial and error, but am stumped, any help really appreciated

Thank you very much Andy! That does what I wanted, and I tweaked it to still display the value of the cell.