Microsoft Excel cannot find the data...
 

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.

Microsoft Excel cannot find the data...
 

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

Microsoft Excel cannot find the data...
 

Thanks Mike, but is not the case. I don't alter any
options, more than that I tried all options and te result
is the same. The only solution I found is to restart
Excel so I suppose the cause is a system variable.

-----Original Message-----
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.
.

.