You can use address references relative to the Cell with Total, like below to sum up all cells from "A" to "L" on rows from 2 to 10, and display the total in the K1 cell:

ObjExcel.Range("K1").FormulaR1C1 = ;
           "=SUM(R[10]C[-10]:R[1]C[-1])"

>Hi! Doing some automation in Excel.
>
>Want to put a sum into a cell from cell say C3 to AB3?
>
>The columns increase or decrease depending on how many products are selected in Foxpro,
>
>Q: How do I do a SUM command using cells references rather than cell names ie CELL(3,3) not A3
>
>or can I work out the name (A3) from the cell reference?
>
>HTMS
>
>TIA
>
>Robin