>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
Try:
.ActiveCell.SpecialCells(xlLastCell).Select
Michael McLain