try:
Formula: copy to clipboard
=Cell("Address",I15)


Using code:
Sub foo()
Range("L15:L25").Formula = "=cell(""address"",RC[-3])"
End Sub