Hi

Have been messing about with this all day and have only got half the job done.
I have an expanding table, which when the last cell in column I is changed I want a macro to run. I can get the cell reference but I just can not get the macro to run. I thought defining it with the "lastrow" would do the trick but apparently not. Any help would be appreciated.

Formula: copy to clipboard
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lRow As Long

lRow = Range("A1").End(xlDown).Row
lastrow = Cells(lRow, Range("I1").Column).Address

If Target.Address(False, False) = lastrow Then
Call lasttrade
End If

End Sub