>>>I know I've asked this question before but I can't seem to find any reference to the answer.
>>>Suppose you have a spreadsheet open in excel, how do you move the cursor to the right or left?
>>>
>>>oExcel.Range('A2').select
>>>oExcel.ActiveCell.value = crsChart.year
>>>
>>>oExcel.MoveRight
>>>
>>>
>>>etc.
>>>
>>>
>>>Thanks
>>
>>
>>oExcel = CREATEOBJECT('Excel.Application')
>>WITH oExcel
>> .Workbooks.Add
>> .Visible = .t.
>> .ActiveWorkbook.ActiveSheet.Range('A2').select
>> .ActiveCell.Value = 2006
>> .ActiveCell.Offset(0,1).Select
>>endwith
>>
Cetin
>
>Thanks Cetin
>That's twice you've answered this for me. I'll do a better job of filing this time.
>- Don
Who really does a filing for such small things anyway:) I don't.
PS: You said you would "loop" and I suspect you're doing an unnecessary loop. I can't know w/o details though.
Cetin