Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to locate record in VBA of Excel2000
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to locate record in VBA of Excel2000
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 worksheet cells themselves, then that was not supported in xl2000. -- Regards, Tom Ogilvy "John.D" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to locate record in VBA of Excel2000
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to locate record in VBA of Excel2000
Thanks. I got it.
-----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to have a record number change for every record | Excel Discussion (Misc queries) | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
Formula to reference another worksheet, locate data, then record i | New Users to Excel | |||
Excel2000 | Excel Programming | |||
Need help autopopulating next new record with previous record data | Excel Programming |