Re: How to locate record in VBA of Excel2000

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 08/02/04 

Date: Sun, 1 Aug 2004 23:00:18 -0400

Find should work in xl2000. I use it all the time.

Post the offending line of code.

As posted in response to an earlier version of this question, perhaps you
are using arguments that were not supported in xl2000.

If you are using it in a User Defined Function (UDF) that is used in the
work*** cells themselves, then that was not supported in xl2000. 

-- 
Regards,
Tom Ogilvy
"John.D" <anonymous@discussions.microsoft.com> wrote in message
news:870c01c47835$084bc640$a301280a@phx.gbl...
> 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