Find Function - ONLY find what is specified

[Giri]

Hi Guys,

At the moment when I search for a string such as "WGG", it is also finding results such as "WGGO". Is there a way to search for only what you specified and nothing else afterwards?

Thank you for your help!!

Kind Regards,

Giri

[Trebor76]

Hi Giri,

Obviously don't know what code you're currently using, but it sounds like you need to change or add the LookAt argument, so it looks something like this:

Find(What:="WGG", LookIn:=xlValues, LookAt:=xlWhole)

HTH

Robert

[Giri]

Hi Trebor,

Thank you for that! I started trying to implement all sorts of overly complicated methods... =D

Kind Regards,

Giri

[Trebor76]

I'm glad it's all sorted