Return Hyperlink Address

You've received a spreadsheet with a list of hyperlinked information. You would like to see the actual links, not the descriptive text. You could just right-click and Edit Hyperlink, but you want something more permanent. This function extracts the hyperlink address, as shown in Figure 4.18.

GetAddress(Hyperlink) The argument is

Hyperlink—The hyperlinked cell from which you want the address extracted. Function example:

Function GetAddress(HyperlinkCell As Range)

GetAddress = Replace(HyperlinkCell.Hyperlinks(1).Address, "mailto:", "") End Function

0 0

Responses

  • karen
    I've just got that getaddress fn working thanks - the others I was trying hadn't worked and yours did!<br /><br />Thats great, but I have a whole column of hyperlinks I want to be displaying, <br />can you tell me how I do that please?<br />i.e. I have hyperlink addresses in f3, f7, f11, f13 etc and they might be 3 or 4 lines apart<br /><br />Thank you.
    8 years ago

Post a comment