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.
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Boldcodes.com
Linkedin LoginToSheet, ToCell1, ToCell2, LinkCaption
Views 149
Downloads 76
CodeID
DB ID
![](/Assets/img/_load804.gif)