Find an exact value not on the activesheet

[tiredofit]

Following from my earlier post:

https://www.mrexcel.com/board/threads/find-value-not-on-activesheet.1156291/#post-5606422

the code to find a value on another sheet is as follows:

Dim abc
    
abc = Sheet1.Cells.Find(What:="somevalue", _
                       LookIn:=xlFormulas, _
                       LookAt:=xlPart, _
                       SearchOrder:=xlByRows, _
                       SearchDirection:=xlNext, _
                       MatchCase:=False, _
                       SearchFormat:=False)

but I noticed this found the value, "somevalue".

If I want to fine variants of it, eg "somevalue1", "somevalue2", etc. I think I would need to add a wildcard like so:

Dim abc
    
abc = Sheet1.Cells.Find(What:="somevalue*", _
                       LookIn:=xlFormulas, _
                       LookAt:=xlPart, _
                       SearchOrder:=xlByRows, _
                       SearchDirection:=xlNext, _
                       MatchCase:=False, _
                       SearchFormat:=False)

but what if I only want to find the EXACT value of "somevalue*" (and not its variants)?

 

[Fluff]

Change xlPart to xlWhole & use "somevalue~*"

 

[tiredofit]

Change xlPart to xlWhole & use "somevalue~*"

Thanks

 

[Fluff]

My pleasure