General information
Category:
COM/DCOM and OLE Automation
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only