Find/Replace not Finding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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. ???
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace 1
Find/Replace 2
VBA, find and replace 2
Numbers change in cell even when formatted as text 4
Toggle between Find and Replace 4
Find and Replace error 3
Find/Replace hundreds of values 9
Find/Replace in multiple worksheets 1

Back
Top