Search for a value in a workbook, and return the Spreadsheet name where it was located.

Hi Leith, Thanks very much that code done the trick for me. I am about to post up another query about creating an "event log" on a user form, if you wish to help.

Thanks again!