How to Search for word in the Entire Workbook

[lbbss]

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.

 

[Anne Troy]

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

 

[Nick Hodge]

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
(e-mail address removed)

 

[lbbss]

thanks

 

[Gord Dibben]

XL97 will not do a search over grouped sheets.

However, it will do a replace over grouped sheets.


Gord Dibben Excel MVP