HYPERLINKGET

There are 2 functions


Remarks

* For instructions on how to add a function to a workbook refer to the page under Inserting Functions
* The equivalent JavaScript function is HYPERLINKGET



HYPERLINKGET

Returns the hyperlink from a cell. The hyperlink can be one of the following types:
existing file or web page
place in your document
e-mail address
If you afterwards change the hyperlink in the cell, you have to press Ctrl+Alt+F9 to have the formula recalculated.


Parameters:
cell = The cell to read the hyperlink from.
text_no_link = Optional, this text will be displayed if the cell doesn't have a hyperlinks. If omitted, the formula will give an empty result for cells without hyperlinks.




HYPERLINKGET_DOMAIN



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext