Search in multiple worksheet

[Peter]

I am using Excel 97 and attempts to search in multiple
worksheets.

I have highlighted / selected those worksheets and go to
Edit --> Find. However, I am only able to find the string
in the first worksheet. Is there any suggestion ?

 

[David McRitchie]

Hi Peter,
I think Find doesn't work very well with Grouped sheets in Excel 97.
Actually it doesn't really work real well with any version compareed to ...

Try Bill Manville's FindLink addin at
http://www.bmsltd.ie/mvp/

 

[Gord Dibben]

David/Peter

I believe David meant to say Jan Karel Pieterse's FLEXFIND.XLA from

http://www.bmsltd.ie/mvp/

Gord Dibben Excel MVP

Hi Peter,
I think Find doesn't work very well with Grouped sheets in Excel 97.
Actually it doesn't really work real well with any version compareed to ...

Try Bill Manville's FindLink addin at

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I am using Excel 97 and attempts to search in multiple
worksheets.

I have highlighted / selected those worksheets and go to
Edit --> Find. However, I am only able to find the string
in the first worksheet. Is there any suggestion ?

 

[David McRitchie]

If you meant "should have pointed to" you're right.
Went back to what I'm used to.

 

[Gord Dibben]

I meant "should have pointed to"

Gord

If you meant "should have pointed to" you're right.
Went back to what I'm used to.