Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some code that plugs in a formula. The formula is not calculating
and instead is showing up as the code itself. This is the formula: ActiveCell.FormulaR1C1 = _ "=IF(OR(RC[-2]=Cond1,RC[-2]=Cond2,RC[-2]=Cond3,RC[-2]=Cond4,RC[-2]=Cond5,RC[-2]=Cond6,RC[-2]=Cond7,RC[-2]=Cond8,RC[-2]=Cond9,RC[-2]=Cond10,RC[-2]=Cond11,RC[-2]=Cond12,RC[-2]=Cond13),""C&I"",RC[1])" Once the code runs, the cells show this: =IF(OR(RC[-2]=Cond1,RC[-2]=Cond2,RC[-2]=Cond3,RC[-2]=Cond4,RC[-2]=Cond5,RC[-2]=Cond6,RC[-2]=Cond7,RC[-2]=Cond8,RC[-2]=Cond9,RC[-2]=Cond10,RC[-2]=Cond11,RC[-2]=Cond12,RC[-2]=Cond13),"C&I",RC[1]) instead of the results. Note: COND1, cond2, cond3, cond4, etc. are a named range in another sheet. Can anyone please tell me why the code is not calculating? As a side note....the cells are formatted as text after code run....and general before the code runs. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with a formula if yes calculate and if no 0 | Excel Discussion (Misc queries) | |||
Formula to calculate 401(k) | Excel Worksheet Functions | |||
Formula does not calculate - Have tried F9 | Excel Worksheet Functions | |||
formula does not calculate | Excel Discussion (Misc queries) | |||
Calculate formula only once. | Excel Discussion (Misc queries) |