Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Office Automation - Excel Question
Message
From
14/09/2010 20:06:43
Robert Wright
Sears
Garland, Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Office Automation - Excel Question
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows NT
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01481195
Message ID:
01481195
Views:
155
How do you determine the number of records (rows containing data) in a column?

Thanks,
Robert Wright

Oops ... I knew I had done this before but just couldn't remember how ... I found the answer in some old code:

lnRecordCnt = VAL(STRTRAN(oExcel.RANGE("A65536").END(XLUP).Address,'$A$',''))


Robert
Next
Reply
Map
View

Click here to load this message in the networking platform