Validating bulk of url`s

As i am having 2000 urls that i need to check whether it is working or no.

Is it possible to have a macro to check whether the urls in colA is working on network i`m having and respond back in col B

If the url is found then colB results with "URL Found".
and If the url is not found then colB results with "Page cannot be displayed"

Sheet1

A B
1 https://www.google.co.in URL Found
2 http://www.fitzgeraldfuneralhome.com...tuary-listings Page cannot be displayed
3 http://www.spitzerfuneralhome.com/ob...tuary-listings Page cannot be displayed
4



Excel 2010

Many thanks Kevin, this is exactly what i want

Thanks for taking the time.