An excellent suggestion which I have incorporated.

Thank you once again, Sergey!


Andrew

>You can store Row # from foundcell and keep calling FindNext until lnRowStored > lnRowFound.
>
>>The only problem I'm having now is that the FIND function is wrapping and so my test to exit the loop never evaluates to true. I can of course put a counter on it and exit as I have a known, finite number of records to peruse. That is a little crude, I'd prefer to find out how to FIND without wrapping and then quit...
>>
>>Andrew
>>
>>>FoxPro doesn't support named parameters. You've to look up in the Excel VBA reference what positional parameers are or use Intellisense. In this case FindNext(0 method have only one parameter

>>>foundcell = oExcel.Range.FindNext(oExcel.ActiveCell)
>>>