R1C1 Style formula does not yield any value

[kumthekarg]

Hi All,

Here is the code I am using to find duplicates amongst certain cell values ( max 12 here). I have been able to implement it but by using a variable in the R1C1 style formula.

Here is the code:

dd = -1 * (12 - Frozen)
ActiveCell.FormulaR1C1 = "=IF(SUM(IF(FREQUENCY(MATCH(RC" & dd & " :RC[-1],RC" & dd & ":RC[-1],0),MATCH(RC" & dd & ":RC[-1],RC" & dd & " :RC[-1],0))>0,1))<12,1,0)"

It does not give me any error but neither gets any value and rather the cell remains blank. Can you please help me find he mistake I am committing here?

Any help is much appreciated..