How to Search for word in the Entire Workbook
 

How can I search for word in the Entire Workbook. Right now I can only do
that by manually switching to a different sheet and searching again for the
same word.

Perhaps this will help:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=159
Otherwise, there are similar articles at:
http://www.vbaexpress.com/kb/kblist.php

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"lbbss" wrote in message
...
How can I search for word in the Entire Workbook. Right now I can only do
that by manually switching to a different sheet and searching again for
the
same word.

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"lbbss" wrote in message
...
How can I search for word in the Entire Workbook. Right now I can only do
that by manually switching to a different sheet and searching again for
the same word.

thanks

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