I need to check a group of computers for a certian file. The computer
names will be in column A. I got it to work with the below code for
cell A1.

How can I get it to loop through all the rows in column A and return
the Y or N to column B?

(If possible please respond to the group as well as by email as I use
Google and it takes forever to see responses)

-----
Sub checkfile()

mname = "\\" + Range("A1") + "\c$\fred.txt"

If Len(Dir(mname)) 0 Then
Range("B1") = "Y"
Else
Range("B1") = "N"
End If

End Sub
-------

Data:
________________
A B
________________
machine1 Y
machine2 N
machine3 N
machine4 Y
machine5 Y