Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display the complete URL instead of a link | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
Link Link Link | Excel Discussion (Misc queries) | |||
Breaking the link | New Users to Excel |