First, let's get the nomenclature.
A file is called a workbook
A worksheet within a file is called a worksheet or sheet. Sometimes tab..
Why the pause?
What you may want is a FINDNEXT macro (look in the vba help index) with a
msgbox ?? If all else fails,

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tom" wrote in message
...
Hi.

I need a procedure to read a name in Document1 then go and find it in
Document2. It then pauses for 10 seconds before returning to Document1 and
reads the next name below. This is repeated until the name is a blank. Any
help is much appreciated.

TIA
Tom