Identify broken http hyperlink

[Gure]

Hi,

I have excel with 1000 lines.
column C contains hyperlink to a http address, about 50% are broken
(404 - File or directory not found) -
I'm loking for a macro color the broken in red. and the good one in green.

Is there a vba function which return FALSE if http hyperlink is broken?

Thanks,
Gur

 

[Hui]

Gure

Firstly, Welcome to the Chandoo.org Forums

Have a look at the VBA solution posted here:
http://stackoverflow.com/questions/22256522/checking-for-broken-hyperlinks-in-excel