A bit more clarification, especially "file in reverse"
I might assume that you mean you want to look in the last sheet, by
location, first.?????
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ChristopherL" wrote in message
...
Hello,

Does anyone have code that will show me how to read a file in
reverse from the end of the file towards the beginning of the file. I
have to find out if an exact phrase such as "the morning brings
another day exists in a file. I am planning on using "Instr" to do
this.

I do not want to use FileSearch's "keyword" search capability
because blanks in the phrase causes too many matches. I.E.: FileSearch
will say a file has the phrase if the file has the words all over the
place in a large file!

Thank you,
Chris