Find/Replace not Finding

S

Sjones

It seems that when using find/replace functions, I am not getting a find when
I know the object I am looking for exists within the workbook. I use
"Workbook" and "Values" as setting for the search but it comes back as not
found. I find it manually then it all of a sudden recognizes it if I
re-search again. Looked for updates but nothing there to fix. ???
 
B

badger_rich

make sure you do not have multiple cells selected when executing the find.
Excel will only look in the selected range if more than one cell is selected.

Another possibility is "Match entire cell contents" is selected. Click on
the "Options <<" button to select/de-select.
 
Top