|  | Excel Use VLookup in vbaHello again.:Ok, now it works fine, That's well! In this case, I always use "Find Method" and "offset property". Here is another sample. Sub SampleFind() Dim rngSearch As Range Dim strWord As String Dim rngFound As Range Dim rngFirst As Range Set ... www.mrexcel.com |  |