>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

I've used in the past:

FOR nRow = 1 TO oExcel.ActiveWorkBook.ActiveSheet.UsedRange.Rows.Count