LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.links
JennyC
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display the complete URL instead of a link Susan Excel Discussion (Misc queries) 2 November 23rd 05 03:30 PM
Changing a Link Mid-way Across Worksheets Frosty Excel Worksheet Functions 0 August 25th 05 12:03 AM
Paste Link - retaining formatting Suzanne Marie Excel Discussion (Misc queries) 1 August 18th 05 02:02 AM
Link Link Link Karla Excel Discussion (Misc queries) 1 May 17th 05 12:07 PM
Breaking the link T New Users to Excel 1 May 4th 05 10:37 PM


All times are GMT +1. The time now is 05:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"