HyperlinkFunction

2. Categories
3. Texts + Strings
4. HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell.
This is the safest way I found across my 25 years with Excel to insert a hyperlink function to a cell in a sheet in an outside workbook.
This is combination of functions (aka formula) to generate the proper link to a cell to be used as hyperlink.
If you just need the actual formula not the VBA of it, you can use http://xlfxs.com/hyperlink/ instead.

Public

Tested

My Own Work