The following works in Excel 2000. I haven't tried it in 97.

lnTotalRows = oExcel.ActiveSheet.UsedRange().Rows.Count

>Can someone tell me if an Excel 97 object (CreateObject('Excel.Application')...) has a property to indicate the actual number of rows and columns containing data?