Excel Made Easy

Determine if hyperlinks are valid in Excel

I have multiple cells in a sheet that have hyperlinks (=hyperlink(...)).
Those hyperlinks point to various websites that tend to change.
I have searched extensively, but not found anything similar.
Can anyone help me on this?

Answer

Use the object MSXML2.XMLHTTP as in the very good example here.

(for formulas, depending on your country, you might have to change ; with , or the opposite

You can find similar Excel Questions and Answer hereunder

1) How can I list all files in a folder using VBA?

2) How can I remove hyperlinks from a range of cells?

3) How to copy files in Excel VBA is explained here

4) Line break in vba message box in Excel

5) How can I shade alternate rows in color using VBA to make it easier to read voluminous data running into hundreds of rows?

6) How can I convert Column numbers into Column names for use in range definition?

7) Here some explanations about XPATH. XPath is a syntax for defining parts of an XML document

8) How can I set FreezePanes in a certain range using VBA?

9) How do I restrict user entry in ActiveX Text Box to just numeric values?

10) How can I extract file name from a full path including folder path and file name?