Search for text in cell...

[tripflex]

Ok, so i got this code of of excelvbamacro.com and it works perfectly fine in searching for something...but i'm having one issue. So say i try to search for "4.2" .. it will find 4.2, it will also find it under "44.2"

Basically i wanted to see if anybody knows how to convert this code to find only exactly what you are searching for in the cell. Thanks for the help guys!

Please Login or Register  to view this content.

[DonkeyOte]

Perhaps change

LookAt:=xlPart to xlWhole

However if the 4.2 appears as a substring - eg "X 4.2" this won't work.