If you can't get Find to work (it should, per Tom's message), you might be
able to substitute Application.Match(Target, Range("A1:A100"),0), or similar.

On Sun, 1 Aug 2004 19:04:24 -0700, "John.D"
wrote:

I can use FIND method in Excel 2003 to locate record in a
data table so that I can return data of other fields of
that record, but in Excel 2000, it doesn't work, does
someone else have method to locate record of a data table
in Excel 2000 or earlier version?
thanks