Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Address of Last Occupied Cell
Message
From
22/11/2006 11:04:08
Fred Kotte
Af
Nairobi, Kenya
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Address of Last Occupied Cell
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01171790
Message ID:
01171790
Views:
46
I use HlcLastCell=oWorkbook.ActiveCell.SpecialCells(xlLastCell).Address() to return the last occupied cell address. However, the result is returned as "$AC$31258" even after setting ReferenceStyle to 2. How can I return the cell reference by Number (ie R1C1 Format) ?

Please help

Fred Matano
Next
Reply
Map
View

Click here to load this message in the networking platform