Hi Gord

Thanks
Now I remember about 97

To many Excel versions now to remember all problems <g
I hope the OP use 2000


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Ron

In 97 Find would not work across grouped sheets.

Replace would work across grouped sheets........go figure<g


Gord

On Fri, 25 Jul 2008 01:53:55 +0200, "Ron de Bruin"
wrote:

I believe 2002 is the first version with this option

The OP can select all sheets and use Find
(right click on a sheet tab and choose select all sheets)

Do not forget to ungroup the sheets after the search