Find Function not workin

Hi All,

Please Login or Register  to view this content.

I (plus other users) are experiencing issues with the find function within excel. Pressing CTRL + F and finding a value which is in the sheet simply doesn't work. The issue has started since I wrote the above code.

Having troubleshooted through google, I cannot find a solution.

Can anyone explain if the code is causing the problem please and if so what needs amending?

Many Thanks
Terry

lookat:=xlWhole sticks, so after you run the code, the Find dialog will have that ticked.

You can reset the Find dialog by doing another dummy search

Please Login or Register  to view this content.