Find() parameters

S

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
 
S

scain2004

Ok, figured it out.

By default LookAt is set at xlPart.

I changed LookAt to xlWhole
 
Top