XL97 will not do a search over grouped sheets.

However, it will do a replace over grouped sheets.


Gord Dibben Excel MVP

On Mon, 4 Jul 2005 18:58:42 +0100, "Nick Hodge"
wrote:

In versions before 2002 (XP) group the sheets (Ctrl + click tabs
(non-contiguous) or shift + click tabs (contiguous)) and then do your search

The option to search the entire book is built into Excel XP and 2003

You might also try Jan Karel's flexfind add-in here

http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.htm