Absolute reference with VBA

[jmicdk]

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

[jmicdk]

I figured it out by doing the following. Thanks

Range("g3").End(xlDown).Offset(0, 3).Select
ActiveCell.Value = Range("K3").Value
ActiveCell.Formula = "=" & (ActiveCell.Offset(1, 0).Address) & "-" & (ActiveCell.Offset(0, -2).Address(False, False)) & "+" & (ActiveCell.Offset(0, -1).Address(False, False))
Selection.Copy
Range(Selection, "J3").Select
ActiveSheet.Paste

[mikerickson]

In R1C1 notation:
R3C2 is the absolute reference to Row 3 Column 3, a.k.a. $B$3

R[3]C[2] is the relative referece to the row 3 columns to the right and three columns down. when put in A1, R[3]C[2] refers to D3

Mixed forms

R1C[2] is the cell in row 1, two columns to the right

RC2 is shorthand for R[0]C2, the cell in Column 2 of the same row.

So to put =$K$3 in any cell

ActiveCell.FormulaR1C1 = "=R3C11"

Does that help.