How can I change a whole column of Hyperlinks that have a different Displayed
text back to displaying the hyperlink address. Ex. http://myplace.com
Displays "My House" change to http://myplace.com Displays
"http://myplace.com"
Ed

This small UDF returns the address of an inserted hyperlink:

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

so

=HYPERLINK(hyp2(A1),hyp2(A1))

will create a new hyperlink in whick both the link and name are the same.
Copy this down an un-used column.
--
Gary''s Student


"Ed" wrote:

How can I change a whole column of Hyperlinks that have a different Displayed
text back to displaying the hyperlink address. Ex. http://myplace.com
Displays "My House" change to http://myplace.com Displays
"http://myplace.com"
Ed