Hi All,

I have a sheet that has variable list of file name and location. So as its variable I don't know the length of the list as it changes.
The file location will be in column C and look like:

C:\Documents and Settings\jtb\Desktop\JB7test\jb1.xls

I would like to run down column C and check that each file exists and if not message that file XXX does not exist.

I am sure it stars like below but I am stuck here, can anyone help?


Sub first()
    For i = 1 To 10
        Cells(i, 1) = i
    Next i
End Sub