Check the options in the Find dialog. Are you setting the
Match Case, or Find entire cells only options? What about
Look in, is that set to formulas or values?

-----Original Message-----
Why do I get the message "Microsoft Excel cannot find the
data you're searching for." despite the fact that the
data are certainly there?
Maybe the context is important: I use a UserForm to find
and modify some data in a worksheet then I unload the
UserForm and I use the find method to find data in the
same worksheet, but the find method seems to work no more.
I get the same message if I use CTRL+F.
What is the cause? How to solve the problem?
Because of the blockage my code could not continue and
the only way to finish the application is to restart
Excel and to skip the procedure that uses the UserForm.
.