Hi,

I have what is certainly a basic problem, but I am stuck.
In the first sheet "Sheet1", I am trying to SUM the values of column C from another sheet 'XXX'. The trick is that the name of this other sheet is a variable, like Sheets(1+i).name , "i" being an integer. I can't find the proper syntax for the formula below.

Any help would be appreciated.
Thank you!

PHP Code: 
ActiveCell.FormulaR1C1 = "=SUM(XXX!C[1])"