Find() parameters

[scain2004]

Is there a way to set the Find() parameters when looking for values in
sheet for only an exact match.

I have:

Set rngJob = Range("WORange").Cells.Find(job, LookIn:=xlValues)

where job is "55-021203-51".

Unfortunately, if it finds "55-021203-51/61/71", it returns tha
address, which is incorrect.

So if job = "55-021203-51" it should pass over "55-021203-51/61/71" fo
not being an exact match.

Any suggestions?

Thanks,
Stev

 

[scain2004]

Ok, figured it out.

By default LookAt is set at xlPart.

I changed LookAt to xlWhole