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

ToSheet, ToCell1, ToCell2, LinkCaption

Views 1 Downloads 0

VBA-Excel Texts + Strings
ANmarAmdeen
876
Attachments
Revisions

v1.0