j8547
asked on
Check excel hyperlink is valid with vba code
I have an excel sheet with the below headings:
ID, Name, Link, Result
I have created a hyperlink in the column 'Link'. There are about 50 entrys at the moment. Some of these links are no longer valid. I wanted a function to run through the list and if the hyperlink is no longer available to put a 'n'o in the result column and 'yes' if it works.
I have been looking for code to validat hyperlinks but cannot find anything. Any help is appreciated
ID, Name, Link, Result
I have created a hyperlink in the column 'Link'. There are about 50 entrys at the moment. Some of these links are no longer valid. I wanted a function to run through the list and if the hyperlink is no longer available to put a 'n'o in the result column and 'yes' if it works.
I have been looking for code to validat hyperlinks but cannot find anything. Any help is appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Links to web pages can be validated using the function posted by fanpages here -> http:/Q_20882190.html