kumthekarg
New Member
- Joined
- Oct 17, 2013
- Messages
- 6
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..
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..