I use FIND method to locate record in a data table, it
works well in Excel 2003, but doesn't work in Excel 2000.
I don't know the reason, as it's the same file just in
different Excel version. and in that case, I can't
distribute my VBA projects to my colleagues who use Excel
2000.

Most likely there are new settings for Find with Excel 2003. It is best to
do all development in the lowest version of Excel someone might have. The
following is a macro recording of Find in Excel 97:

Selection.Find(What:="a", After:=ActiveCell, LookIn:=xlFormulas, LookAt
_
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False).Activate

Check your statement against this, and eliminate parts that don't match up.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"John" wrote in message
...
I use FIND method to locate record in a data table, it
works well in Excel 2003, but doesn't work in Excel 2000.
I don't know the reason, as it's the same file just in
different Excel version. and in that case, I can't
distribute my VBA projects to my colleagues who use Excel
2000.