Well Ken, that's it! Your project is not only working great but it's :cool cool too. Thanks very much.

Maybe it's a dumb question but....[VBA] .Range("A2:A" & .Range("A65536").End(xlUp).Row).ClearContents
.Range("A1").Value = "Location of workbooks holding the term: " & SearchText [/VBA] .....what is meant by ("A65536")? How can I put the hyperlinks in cells B3, B4, etc?

Thanks again for all your time and trouble .

Regards.