Search a string in all worksheets ?

[Peter]

I am searching for a string say ABC in all worksheets in
Excel 97. However, it seems that it only allows me to
search it in the current worksheet.

Is there any suggestion ?

 

[CLR]

Hi Peter............

In XL2k, I just highlighted all three sheets using Right-click on one tab
and choosing Select all sheets..........then did Edit > Find > and typed my
search string in the window and hit "Find next" repeatedly and it cycled
through all three sheets finding the string...........is that what you're
wanting to do?

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

OOOOOps...........sorry, didn't read the part about you're using
Excel97........maybe it don't work the same there.........

Vaya con Dios,
Chuck, CABGx3