I have a sheet (attached) with roughly 22,400 hyperlinks that go to reviews on products. The problem is the person that created this sheet didn't have a plan for products that are removed from the web. So, needless to say there lots of links in here that lead to 404 web errors as the pages no longer exist. Is there a Macro or Formula I can run to have it ping all of these hyperlinks for a 404 or other error if the webpage no longer exists? I deleted all but about 250 of the links so you could see a subset of what I am working with in the attachment.
Thanks,
Jason
Bookmarks