>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
If it's not broken, fix it until it is.
My Blog