>>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