Search a string in all worksheets ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 18 Jun 2004 06:51 GMT

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 ?

Reply to this Message

CLR - 18 Jun 2004 12:09 GMT

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

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

Reply to this Message

CLR - 18 Jun 2004 12:11 GMT

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

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

Reply to this Message