View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Kubicki Mark Kubicki is offline
external usenet poster
 
Posts: 89
Default 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