See http://www.berezniker.com/content/pages/visual-foxpro/excel-finding-last-row-column-or-cell

>How do you determine the number of records (rows containing data) in a column?
>
>Thanks,
>Robert Wright
>
>Oops ... I knew I had done this before but just couldn't remember how ... I found the answer in some old code:
>
>lnRecordCnt = VAL(STRTRAN(oExcel.RANGE("A65536").END(XLUP).Address,'$A$',''))
>
>
>Robert