How do I search for a string across multiple worksheets in Excel?

G

Gord Dibben

What version of Excel?

97 has a problem searching(find) across grouped worksheets.

No problem with the Replace feature.

Newer versions work OK.

Make sure you have "within workbook" enabled in the Find Options.

If you are running version 97, download Jan Karel Pieterse's FlexFind add-in.

http://www.jkp-ads.com/Download.htm


Gord Dibben Excel MVP
 
B

BBiletch

Thank you!!!!

Gord Dibben said:
What version of Excel?

97 has a problem searching(find) across grouped worksheets.

No problem with the Replace feature.

Newer versions work OK.

Make sure you have "within workbook" enabled in the Find Options.

If you are running version 97, download Jan Karel Pieterse's FlexFind add-in.

http://www.jkp-ads.com/Download.htm


Gord Dibben Excel MVP
Click to expand...
 
Top