Showing URl of link?
 

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

Showing URl of link?
 

Hi Jenny,

Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel...perlinkaddress

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JennyC" wrote in message ...
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