Why "find" doesn't work in one workbook, but it does in another o.

[Hedwig63]

Why "find" does not work in one workbook, but it does in another?
In workbook (A), I am typing the correct name, because I am looking at it,
but a window tells me "Microsoft Excel cannot find the data you'r searching
for. ..."
Whereas in a different workbook, (B), I enter a couple of letters and it
finds words that have those letters in them.

What could I possible have done different in workbook (A)

 

[Govind]

Hi,

Make sure you dont have any range which is selected. Lets say for eg.
you hae selected a range from A1 to D20, the find will work only between
that range.

Hence make sure you haven't selected an range, and then try the "Find"
utility

Govind.

 

[Markus L]

Why "find" does not work in one workbook, but it does in another?
In workbook (A), I am typing the correct name, because I am looking
at it, but a window tells me "Microsoft Excel cannot find the data
you'r searching for. ..."
Whereas in a different workbook, (B), I enter a couple of letters and
it finds words that have those letters in them.
What could I possible have done different in workbook (A)

Verify that the "Look in" settings in the Find dialog box (Formulas, Values,
Comments) are identical in both workbooks.

The following is taken out of Excel VBA online help:
The settings for LookIn, LookAt, SearchOrder, and MatchByte are saved each
time you use this method. If you don't specify values for these arguments
the next time you call the method, the saved values are used. Setting these
arguments changes the settings in the Find dialog box, and changing the
settings in the Find dialog box changes the saved values that are used if
you omit the arguments. To avoid problems, set these arguments explicitly
each time you use this method.