I searched the forum but i did not see anything to help me understand how to fix this.
I want to copy a formula with an absolute reference to a range.

The reference that should be absolute is R[1]C[0]. It can either be $K$3 or the cell selected in the first line of the code.
Any help appreciated ,
Thanks

Range("g3").End(xlDown).Offset(0, 3).Select
ActiveCell.Value = Range("K3").Value
ActiveCell.FormulaR1C1 = "=R[1]C[0]-RC[-2]+RC[-1]"
Selection.Copy
Range(Selection, "J3").Select
ActiveSheet.Paste