Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting rows of an Excel 97 worksheet
Message
From
28/12/2000 23:09:38
Chrita Lee
ProMOS Technology Inc.
Hsinchu, Taiwan
 
 
To
23/12/2000 09:30:04
Charles Richard
Nvo Management Systems
Boisbriand, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Counting rows of an Excel 97 worksheet
Miscellaneous
Thread ID:
00456575
Message ID:
00457663
Views:
26
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform