Find Method

[omnisautnihil]

I have written a code that searches down a column for a given entry. My problem is a simple one. If I tell it to find A125, and it comes across A1250, it simply notes the A125 and continues on. I want to specify that it MUST be as its searching. So i pass the A125 into the "What" but what setting do I use to make sure its the exact entry. Either that or what code would I use to make it Find the next entry. (Obviously this is if I need to write a simple if to check equality.)

Thanks.

 

[Gary McMaster]

Maybe the LookAt:=xlPart or LookAt:=xlWhole parameters of the Find method is what you need?

Gary

 

[omnisautnihil]

Ok I wasn't sure what that parameter meant. Thanks, it definitely helps.