Search a string in all worksheets ?

  • Thread starter Thread starter Peter
  • Start date Start date
P

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 ?
 
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
 
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
 
Back
Top