Using FIND with multiple worksheets selected ( [Grouped] )

[Drdave1958]

Would someone explain how the Edit/Find command works with a group of worksheets selected. For instance, I have six worksheets selected, and I know the word "DATE" is on all of them. When I use "Edit/Find" and search for the word "DATE", it finds the word on the active sheet only. However if I search for the word "TEST" which I know is only on sheet3, (I'm starting my search from sheet1 each time), It jumps to sheet3 and finds the word "TEST". My question: Is there a way to search for each instance of a word on each sheet without selecting each sheet one at a time?

Thanks, Dave

 

[RichardS]

Not sure if this will help, but have a look at PaddyD's response to something similar at

http://216.92.17.166/board/viewtopic.php?topic=12993&forum=2

Richard