Grouping works. There's an interesting clue to work with.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Have you tried grouping the sheets and do your EditFind?

Excel 97 would replace across grouped sheets but not find.

Don't know about 2000..........never used that version but I thought it
had the
feature. Guess not.


Gord

On Wed, 07 May 2008 20:13:07 GMT, "JoeSpareBedroom"

wrote:

I'm using Excel 2000, and I see no Options thing available to me as you
described it. My only choices a

Search by: Rows or Columns
Look In: Formulas, Values or Comments

Two check boxes: Match Case & Find Entire Cells Only

That's all I have.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
That functionality is built-in after Excel 97

EditFindOptionsWithin. Enable "Workbook"


Gord Dibben MS Excel MVP

On Wed, 07 May 2008 13:31:17 GMT, "JoeSpareBedroom"

wrote:

Anyone know of a way to search across all sheets in a workbook? Is there
a
way to add this functionality to the normal Find feature?