For each URL, send a GET request with the XMLhttp object. Its Status property contains the http status code of the response. Google the terms mentioned and you should find examples. Similarly, search for something like 'VBA loop through cells in column' to loop through the URLs.