HYPERLINKGET

There are 2 functions


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



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