>>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
Hey Chris,
Really neat and short :) Thanks for sharing.
Cetin