Need formula to get the hyperlink out of a cell

[Me]

I have a spreadsheet with a column with a text string and
an associated hyperlink. It displays "Display" and if you
put the cursor over it a little pop-up shows up which
displays a hyperlink "http://www.microsoft.com". If you
click on it a browser opens to a link that is attached to
it.

I know there's a way to suck out the hyperlink using some
sort of formula. I've done it before. I just can't
remember how and have been unable to find it in Help.

Any additional help would be greatly appreciated.

 

[pmarino]

try Range("A1").Hyperlinks(1).Addres

 

[David McRitchie]

See my page on hyperlinks
Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Function HyperlinkAddress(cell)
On Error Resume Next
HyperlinkAddress = cell.Hyperlinks(1).Address
if hyperlinkaddress = 0 then hyperlinkaddress = ""
End Function

=HyperlinkAddress(A3)
=personal.xls!HyperlinkAddress(A3)