Is this an actual list object or range?expanding table
Perhaps this...
![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 9 Then Application.EnableEvents = False If Target.Row = Cells(Rows.Count, 9).End(xlUp).Row Then Call lasttrade Application.EnableEvents = True End If End Sub
Bookmarks