Showing URl of links ??

J

JennyC

Hello - Newbie question:

I have an Excel file (98) with 1600 names of people
Each name is a link to their personal file
I need to know how many of the links point to the 'under construction' page
Is there a way to automatically show the URL's so that I can count how many new
personal files we need to create ?

I can only seem to show them one at a time :~((

TIA, Jenny
 
B

Bob Phillips

Jenny,

You could add this UDF (Alt-F11, menu Insert>Module, and then copy it in )

Public Function GetURL(rng As Range)
If rng.Count = 1 Then
GetURL = rng.Hyperlinks(1).Address
End If
End Function


and use it in B1 as =GetURL(A1) and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

JennyC

Right!

Sounds a bit like abracadabra but I shall try it next year when I get back in
the office :~))

Thanks Jenny
 
J

JennyC

Bob

A million thanks - works a treat :~))

Maybe I'll have to think about learning VB.........!

Jenny
 
Top