Thank you. I think, it is the best solution among the answers.
But if we consider how long it take each of us to find the answer of 'how to do it in Excel', I would say Excel is useful, not great. But this forum and our community is REALLY GREAT!

>>>>>>>>>>>>>>>>>>>> Previous message
>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
>Charles Richard

A more straightforward way:

? ActiveSheet.UsedRange.Rows.Count
? ActiveSheet.UsedRange.Columns.Count

Excel is REALLY GREAT!!!

Chris Lee