Display offset address

[Jaeger]

Hi All,

I'm trying to display in a cell the address of a cell 3 columns to the left (0,-3), but I need to do this for a range of cells. I was ideally looking for a formula to just place in a cell, but I can't seem to do this, alternatively a vba code would be fine. At the moment I have:

Private Sub Worksheet_Activate()

    Range("L15").Text = Range("L15").Offset(0, -3).Address

End Sub

I get an error saying object required.

Any help would be appreciated.

[Olly]

try:

=Cell("Address",I15)

Using code:

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

[Jaeger]

That'll do. Thanks!