Using find- doesn't always seem to work

  • Thread starter Thread starter steve vo
  • Start date Start date
S

steve vo

I have a number of sheets in an excel document. I'm
searching for a particular name that I know is in there. I
select all sheets (after right clicking on a sheet tab)
then press control f. It comes back with the response that
the word cannot be found.
Now most of the time it will find it but inexplicably
sometimes it won't. (correct spelling and punctuation is
being used)
 
Specifically, FlexFind.zip by Jan Karel Pieterse.

xl97 doesn't always (ever/never?) give good results with Finding across grouped
sheets.

But if you're using xl2k or higher, make sure you have all the settings correct
(match case/match entire cell contents and even formatting in xl2002 and above).
 
Back
Top