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.