Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How come it say "Microsoft Excel cannot find any data to replace"? | Excel Discussion (Misc queries) | |||
Microsoft Excel cannot find data you are searching for | Excel Worksheet Functions | |||
i cant find microsoft office or excel for spread sheets. i have wo | Setting up and Configuration of Excel | |||
Where do I find my Task Pane in Microsoft Excel? | New Users to Excel | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) |