Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
Formula Error | New Users to Excel | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Formula error with Mac resulting in '#NAME' error | Excel Programming | |||
Formula error... | Excel Discussion (Misc queries) |