General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only