OK, something is going on here in Excel 2007 vs. 2003. I have a cell with a
formula in it that was coded in vbscript: ActiveCell.FormulaR1C1 =
"=(R[0]C[-4]+R[1]C[-4])*R[+1]C[2]" When I run this in Excel 2003 or 2007 it
puts the formula in effectively as something like "=(A12+A13)*G13".

In Excel 2003 it calculates the value of the cell correctly. When I run
this in Excel 2007 it puts a big fat 0 in the cell which I can see is wrong
based on the contents of A12, A13 and G13. I need to change the formula to
"=SUM((A12+A13)*G13)" for Excel 2007 to work.

What's going on here?

Thanks!

-Richard K