I am trying to convert the following workbook reference/formula into an R1C1 reference to put into a macro.
Note: the active/selected cell in this case is C15.
=IF(D15=$D$4, $C$4, "")
The code I have is this:
Thanks in advance,![]()
ActiveCell.FormulaR1C1 = "=IF(RC[+1]=R4C4,R4C3,"")"
Rick
Bookmarks