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

Please Login or Register  to view this content.

[jmicdk]

I figured it out by doing the following. Thanks

Please Login or Register  to view this content.

[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

Please Login or Register  to view this content.

Does that help.