PDA

View Full Version : Find Function - ONLY find what is specified



Giri
06-12-2012, 11:10 PM
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
06-12-2012, 11:47 PM
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
06-13-2012, 05:01 AM
Hi Trebor,

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

Kind Regards,

Giri

Trebor76
06-13-2012, 07:27 PM
I'm glad it's all sorted :)