find (exact match) ?

[mark kubicki]

i'm using the statement:
Set c = .Find(What:=Range("B" & CStr(r)).Value,
LookIn:=xlValues)

however, as an example, if the value i'm looking for is "Macklowe
Residence", the result is being returned at the first instance of "Macklowe"
(such as: "Linda Macklowe Residence");

i need to the search to find the exact match (Linda is Mr. Macklowe's mom,
and we did a small project for her in the middle of the Macklowe Residence
Project !!, not to confuse the 2...)

thanks in advance, mark

 

[Tom Ogilvy]

Set c = .Find(What:=Range("B" & CStr(r)).Value, _
LookIn:=xlValues, Lookat:=xlWhole)