software

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
Hi Jenny,

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

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

quot;JennyCquot; gt; wrote in message ...
gt; Hello - Newbie question:
gt;
gt; I have an Excel file (98) with 1600 names of people
gt; Each name is a link to their personal file
gt; I need to know how many of the links point to the 'under construction' page
gt; Is there a way to automatically show the URL's so that I can count how many new
gt; personal files we need to create ?
gt;
gt; I can only seem to show them one at a time :~((
gt;
gt; TIA, Jenny
gt;
gt; --
gt; Jenny
gt; (Rotterdam the Netherlands)
gt; remove the squirrel to reply
gt;
gt;