How to set the default FIND dialog setting back to "XlPart" instead of XlWhole, if code changes it?

[makiwara]

Hi! I have a code, with this part in the "Thisworkbook" module:

Set rw = ws.Range("A:A").Find(Cells(Target.Row, 1).Value, , xlValues, LookAt:=xlWhole)

And after it runs, the "Find" tab saves it as setting and search for xlWhole, so I have to set it back every time manually to xlPart. (If I add a same line of code but with an "xlPart" ending, it doesn't change the setting unfortunately.

Can you help me, what could I add to my code to solve this difficulty?

Have a nice day!

 

[Fluff]

Try adding this as the last line of code

Set Rw = ws.Range("A1").Find("*", , xlValues, LookAt:=xlPart)

 

[makiwara]

Thank you my Master!:D

Try adding this as the last line of code

Set Rw = ws.Range("A1").Find("*", , xlValues, LookAt:=xlPart)

 

[Fluff]

Glad to help & thanks for the feedback