Don

For the purpose of setting values to various cells you don't have to select the cell first.

oExcel.Range('A2').Value = "Whatever" will put "Whatever" in cell A2.

But to answer your question the syntax is:

lo.ActiveSheet.Range("A2").Activate Or oExcel.Range('A2').Activate

Your .ActiveCell.Value = "something" will have the same effect as above.

Regards

Mathias

>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