Find stops working

[sharpeye]

Hi everyone, not sure if this is the right place for this question but hope there may be someone with ideas that might help.
The Find feature occationally stops working and its a pain when it happens.
I use it a lot and it works fine and then for some random reason that I dont know about it will return

We couldnt find what you were lookin for.

As soon as that happens it will literally not find anything, even a single character. I can get it working again but the only way is to close every worksheet I have open and restart excel which is a proper pain.

Has anyone else had this issue?

Im using 2019

thank you

 

[Alex Blakenburg]

I noticed that you use macros.
When find stops working, have you checked all the parameters shown below to make sure they have been cleared.
Once used eg by a macro, they stick until you change them or close and restart excel.

 

[sharpeye]

I noticed that you use macros.
When find stops working, have you checked all the parameters shown below to make sure they have been cleared.
Once used eg by a macro, they stick until you change them or close and restart excel

 

[sharpeye]

Hi Alex, thanks for the reply.
I do use macros but they are not in use when find stops working. When I am using search, it works perfectly every time until it cant find something, the search is genuine and not a search for something that is not present in my worksheet and as soon as it fails to find what im searching for it is game over and restart and then it works again fine.
I have gone into the options which souldnt have changed anyway but theres nothing in there that souldnt be. Its just odd

 

[Alex Blakenburg]

I'm afraid I don't have any other ideas for you.
Does it only happen in the one workbook ?
If so is it an xlsm workbook ?
Do you have any add-ins turned on ?

Grasping at straws, if you copy this into the immediate window and hit enter to run it, does it kick start it ?

Application.FindFormat.Clear: ActiveSheet.UsedRange.Find(what:="*", lookat:=xlPart, SearchFormat:=False, MatchCase:=False).Select

 

[sharpeye]

Hey Alex
Im still not sure why its happeneing but I just found something that seems to get it working again.
So I use copy from one worksheet and paste it in find to use in another worksheet. It usually works for most searches but when it does stop working I can go into the options as you posted in your picture and I can then use the drop down arrow by the search box and select a previous entry which then seems to make it work again.
Seems very strange !!!!

 

[Alex Blakenburg]

Thanks for the update. Unless my previous post shed any light on the subject I am afraid I don't have an answer.
You could try repairing or reinstalling Excel.

 

[sharpeye]

Thanks for the update. Unless my previous post shed any light on the subject I am afraid I don't have an answer.
You could try repairing or reinstalling Excel

I think now that I've found a solution I'll run with it for now, is a lot less time consuming than saving everything and restarting.
Thanks for getting involved I do appreciate it =)