Searching an entire workbook for text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PCLIVE - 18 May 2005 19:46 GMT

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

Reply to this Message

Ken Wright - 18 May 2005 20:17 GMT

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.

Signature

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

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

> 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
[quoted text clipped - 4 lines]
> Thanks,
> Paul

Reply to this Message

Dave Peterson - 18 May 2005 20:35 GMT

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.

> 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
[quoted text clipped - 4 lines]
> Thanks,
> Paul

Signature

Dave Peterson

Reply to this Message

PCLIVE - 18 May 2005 20:42 GMT

Thanks Dave.

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

Thanks again,
Paul

> xl2002+ has that option built in (like Ken wrote).
>
[quoted text clipped - 12 lines]
>> Thanks,
>> Paul

Reply to this Message

Ken Wright - 18 May 2005 20:48 GMT

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

Cheers Dave :-)

Signature

> Thanks Dave.
>
[quoted text clipped - 19 lines]
> >> Thanks,
> >> Paul

Reply to this Message