use range of cells with URL's to files and check it they exist, if false delete to end

[2k05gt]

I am not sure how I want to word the title

This is Excel 2010 on Windows 7
Trying to figure out a VB Script but don't know where to start.

I have a sheet for each month. lets take September 2013
A Column with 200 Servers (A1:A200) on the Intranet listed as server-1/, Server-2/ Server-3 ... Server-200/
Each Server lists a location of a file for each day (31 columns per row)

I am trying to check for the existence of the files on each server (The Cells contain the URL and File Name in Range B2:AF201) starting with server-1 check the URL in B2 if it exists, go to C2, Continue with that row until
the file check is False (The Page will show a 404 error) if not found delete cell url and continue.
do this for all 200 rows