Help with Find function

Ill try this again. I have to type 64732964372891 numbers in per day.
I have to check that they are not already typed in

I have this messy code. I have no problem finding a duplicated number and selecting it.
The problem is that unlike MS suggest (mute if not found), if the search is not found, the cursor gets repositioned out of the next cell and back into the original cell which is wasting time
The solution is to complete a search as part of the if statement (IF duplicate is found THEN Select duplicate cell ELSE Select cell before search performed)
I simply dont know how to return The Range where and if a duplicate is found.

Any idea?

Please Login or Register  to view this content.

Maybe something like this?

Please Login or Register  to view this content.