find (exact match) ?
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
|