The R1C1 formula is relative to the cell in which it is inserted. If you want an absolute reference, then when you enter it in Excel, surround the column and row components with $ so you enter:

=$R$47

And in the macro code this will be recorded as:

activecell.formular1c1 = "=R47C18"