Is it possible to set up the "Find" so that when searching for something in
an excell document it will seach all worksheets in that document to find what
is required.

Hi,

View this web site using this URL:
http://www.ablebits.com/excel-find-r...r2=findreplace

Challa Prabhu

"Simpson Western" wrote:

Is it possible to set up the "Find" so that when searching for something in
an excell document it will seach all worksheets in that document to find what
is required.

hi,
see this site...
http://www.bmsltd.ie/MVP/
download the FLEXFIND utility. it's an addin for excel versions 97 to 2003.
I used it on 97 and 2000 and it works pretty good. I haven't installed it
2003 because i wrote my own version of flexfind. but my version doesn't work
as well as flexfind. i need to work on it some more. sigh.

regards
FSt1

"Simpson Western" wrote:

Is it possible to set up the "Find" so that when searching for something in
an excell document it will seach all worksheets in that document to find what
is required.

Edit|Find (to show the dialog)
If you don't see all the options at the bottom of the dialog, click that Options
button.

You can specify what you want to search through in the Within dropdown (sheet or
workbook).



Simpson Western wrote:

Is it possible to set up the "Find" so that when searching for something in
an excell document it will seach all worksheets in that document to find what
is required.

--

Dave Peterson