ExcelBanter - Checking Hyperlink

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Checking Hyperlink (https://www.excelbanter.com/excel-discussion-misc-queries/105116-checking-hyperlink.html)

Checking Hyperlink

Hi guys,

I hope you can help me, I have a list of 7000 hyperlinks (string) and
some of them are broken.

How can I and check them and put their status in the next column?...
something like: "OK", "Broken"

Thanks
A.

All times are GMT +1. The time now is 02:22 AM.