Store Cell Reference using VBA

[OfficeMonkey]

My question is simple, but I can't seem to find the answer anywhere.

I want to use VBA to store a cell reference. For example, if I wanted cell B2 to reference cell A1, how do I store B2 as "=A1" using VBA? While I'm asking this, can you also teach me how to store B2 as an absolute reference "=$A$1"?

To clarify again, I want want B2 to reference A1, not simply store the value in A1.

Thanks!

 

[VoG]

Try

Range("B2").Formula = "=A1"

or

Range("B2").Formula = "=$A$1"

 

[OfficeMonkey]

Great, thanks for the help VoG!