Showing URl of links ??

[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

--
Jenny
(Rotterdam the Netherlands)
remove the squirrel to reply

[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)


"JennyC" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> --
> Jenny
> (Rotterdam the Netherlands)
> remove the squirrel to reply
>
>

[JennyC]

Right!

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

Thanks Jenny

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> 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)
>
>
> "JennyC" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> > --
> > Jenny
> > (Rotterdam the Netherlands)
> > remove the squirrel to reply
> >
> >
>
>

[JennyC]

Bob

A million thanks - works a treat :~))

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

Jenny

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> 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)
>
>
> "JennyC" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> > --
> > Jenny
> > (Rotterdam the Netherlands)
> > remove the squirrel to reply
> >
> >
>
>