Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving the excel cursor from foxpro
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00235211
Message ID:
00236158
Views:
21
>>Im really stuck on this. CAn you help me.
>>
>>I want postion the cursor at A1
>>move down to the last cell that is not empty
>>then move right to the last cell that is not empty
>>then move two cell down
>>
>>
>>how do I write this ? I can get it to move either down or right but not both
>>
>>how would you write this. My sheet is "objsheet"
>>
>>thanks jason
>Jason,
>If you send the keyboard command Control+End to Excel, the rightmost cell in the last row with data will be the actice cell. I am not sure how to get action in a program. I will try it out when I get home. I do not have MOM(Microsoft Object Model) with me.
>Let me know what you are calling the last cell not empty. If this is a new workshhet that has not been touched by human hands there will be no confusion. If a user has been able to enter data, then there will ahve to be a validity check. Cells may appear to empty, but an invisible entry can exist.

Record a macro in Excel and copy it into VFP. It only takes a little tweaking.
John Harvey
Shelbynet.com

"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright
Previous
Reply
Map
View

Click here to load this message in the networking platform