General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Moving the excel cursor from foxpro
I created a excel spreadsheet from foxpro. I am trying to position the cursor so that I can begin putting some formulas in. I have data in cells A1 to K16.
I am trying to tell the cursor to start at A1 go to right until you hit the last cell with data. then go down until you hit the last cell with data. I then want it to go down two more cells so I can enter a formula there. For this particular spreadsheet I know what my cell location that I want to be are (K16 + 2 or K18). But as the data set grows I wont. In excel you accomplish the movement by pressing the control and right arrow key and then control and left arrow key.
this is what I have in my fox pro code.
>with objsheet
> .Range("A1").Select
> .Selection.End(xlToRight).Select
> .Selection.End(xlDown).Select
>endwith
Line 1 works fine (it starts at the home position)
line 2 works fine (it takes me to A16)
Line three is where I lock up. It should take me to K16.
Any ideas
thanks Jason
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