Searching an entire workbook for text

  • Thread starter Thread starter PCLIVE
  • Start date Start date
P

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
 
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.
 
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 :-)
----------------------------------------------------------------------------

PCLIVE said:
Thanks Dave.

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

Thanks again,
Paul
Click to expand...
 
Back
Top