Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LastCell : Excel Automation
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00990663
Message ID:
00991157
Views:
16
>Any reason you didn't use
loExcelSheet.UsedRange.Rows.Count
?


I found that UsedRange could sometimes include empty cells (probably because they were accessed and cleared at one point), which may wreak havoc on certain things I'm trying to do. That's why I prefer to use the End property, which will always get me to the last non-empty cell (at least from what I've experienced).

Laterness,
Jon
Jon Rosenbaum
Devcon Drummer
Previous
Reply
Map
View

Click here to load this message in the networking platform