In some cases the actual number of rows containing data may be less then the number of rows in the document.
In Excel you can use CTRL+END to go to the document bottom.
So, while automation to go to the document bottom you can use:
ObjExcel.SendKeys ("^+{END}",-1)
Then you can use ObjExcel.ActiveWindow.RangeSelection.Address to see where you are.

Best Wishes

>>>>>>>>>>>>>>You message below
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?

Thanks