The code you posted doesn't work? Or something else involving "SUME"? Your
code works for me as long as I have a value in Sheets("A").Range("A10").

--
Jim
"MM_KAT" wrote in message
...
| 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!