Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Address of Last Occupied Cell
Message
From
22/11/2006 11:15:24
Sergey Berezniker
New York, United States
 
 
To
22/11/2006 11:04:08
Fred Kotte
Af
Nairobi, Kenya
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: 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:
01171802
Views:
6
This message has been marked as the solution to the initial question of the thread.
>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) ?
#DEFINE xlR1C1	-4150
? oSheet.Cells.SpecialCells(xlLastCell).Address(,,xlR1C1)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform