Try something like
Dim Rng As Range
For Each Rng In Range("A1:A10")
If Dir(Rng.Text) < "" Then
' file exists
Else
' file doesn't exist
End If
Next Rng
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Magnivy" wrote in message
...
Greetings!
I have a macro that opens files for which the path is indicated
in a range,
say A1:A50. Before I run the macro, I would like to test
whether the file
paths are entered correctly. I'm trying to create a macro that
would test
whether the files contained in cells A1:A10 exist, but cant
come up with
anything.
Any insight you provide would be greatly appreciated.
Sincerely,
Magnivy