Can anyone tell me how to make the .find method in vba(excel) find an exact match.

I need to return nothing from the method when an exact match is not found.

ex:
I need to return "nothing" on a search for "1230L200"...even if "1230L20" is in the list.

.find is returning a range even if the match is only partial...


Clear as mud?

Please help.

can you use Lookin:=xlWhole as in .Find("123oL20",Lookin:=xlWhole)

Brian