ActiveCell.Formula to equal a specific cell

[Aaron]

I'm trying to set my active cell to equal B34. But when I do it, the formula
is in R1C1 format. Next time the macro runs, B34 will be in a different
position relative to my active cell. What should the code look like if I
want ActiveCell.Formula = B34???

 

[Mike H]

Try,

Range("b34").Copy
With ActiveCell
.PasteSpecial
End With

Mike

 

[JLatham]

or one of these:
Activecell.Formula = "=$B$34"
or
ActiveCell = Range("B34").Value