Expose hyperlinks

[R]

Is there a way to show the underlying hyperlinks for a
group of cells at once?

 

[David McRitchie]

Hi <insert missing name here>,

You can use a User Defined Function such as one of a few that you can
can find on my Build Table of Contents and Working with Hyperlinks page
http://www.mvps.org/dmcritchie/excel/builotoc.htm#url

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

usage:
=HyperlinkAddress(A2)
=personal.xls!HyperlinkAddress(A2)

It is excellent for pasting your favorites into column A, and
having Column B show the actual url.

Instructions to install see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Bill Manville's solution, 2002-07-26, covers Excel links as well.
http://google.com/[email protected]