Hi,
I am trying update formulas in cells via script. The formula is assigned
correctly, but doesn't work. Instead of value there is #NAME? error tag. But
when I click on formula row in the sheet and pressing Enter - all become
working! It appear with all simple formulas like SUME. I am desperate...

For x = 1 To 5
Range("A" & x).Formula = "=IF(B" & x & "=0,C" & x & "*" & _
Sheets("A").Range("A10") & ",0)"
Next x

Thanks!