Making a cell a constant "$"

[gheyman]

I recorded this code. Put I should have made this Pricing SUmmary'!$G$3

How would you change this to make it a constant? I am copying the cell over so I need the formula to stay on $G$3

'Pricing Summary'!R[-4]C[1]

 

[Dryver14]

you have to actually reference that cell
for instance b3

=R3C2

 

[Norie]

Why not just change from R1C1 to A1 notation?

'Pricing Summary'!$G$3

Though if this is a formual you would need to change all the references.

PS Can't you turn off the R1C1 thing when recording a macro?