http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom



"Tommy" wrote in message
...
How do we enter UDF (user defined function) into EXCEL and which menu do
we
need to click?

Function hyp(r As String) As String
hyp = Range(r).Hyperlinks(1).Address
End Function


"Gary''s Student" wrote:

If there is a hyperlink in C5, then the UDF
=hyp("C5") will return the URL


Here is the UDF:

Function hyp(r As String) As String
hyp = Range(r).Hyperlinks(1).Address
End Function
--
Gary's Student


"polytx" wrote:

How do I retrieve the url portion of a cell that has a hyperlink stored
int
it. The value function only returns the readable text.