View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
serban serban is offline
external usenet poster
 
Posts: 2
Default 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.
.

.