FIND across multiple sheets

[MightyMouse]

Is there a way to make the Edit-Find function look across all the sheets within a given workbook? I have a workbook with 7 sheets - all the sheets contain phone numbers. How can I use the find function just once, instead of 7 times, to look for a specific phone number that could be anywhere in the workbook?

 

[Glaswegian]

Hello

Have a look at Nimrod's solution in this thread:

http://www.mrexcel.com/board2/viewtopic.php?t=114750&highlight=

Regards

 

[MightyMouse]

Nimrod's code... now THAT'S cool!!! Thanks very much!!!