Searching an entire workbook for text

[PCLIVE]

Does anyone know a way to do a text search in a workbook? This for a
Workbook that has a bunch of worksheets and I'm trying to find away to
search the entire workbook without having to go to each worksheet.

Is there a simple way to do this?

Thanks,
Paul

 

[Ken Wright]

Take a look at the Find dialog box, hit the 'OPTIONS' button and take a
close look at the option that says 'WITHIN'

Hit the dropdown and you will see the option to search in 'WORKBOOK' instead
of sheet.

 

[Dave Peterson]

xl2002+ has that option built in (like Ken wrote).

If you're using xl2k or previous, you may want to try Jan Karel Pieterse's
FlexFind addin:
http://www.oaltd.co.uk/MVP/

Actually, it will work in all versions of xl.

 

[PCLIVE]

Thanks Dave.

I'm currently using XL2000. I will look into the addin.

Thanks again,
Paul

 

[Ken Wright]

Oops - forgot that that option turned up in 2002 - apologies

Cheers Dave

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Thanks Dave.

I'm currently using XL2000. I will look into the addin.

Thanks again,
Paul