Hi,
Im using automatical change of value in cell J2 (formula dependent), how should I setup next code to recognize the change of cell value J2 ?
Right now, this code works, but only if I manually change value in J2.
Im using automatical change of value in cell J2 (formula dependent), how should I setup next code to recognize the change of cell value J2 ?
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Sheet2.Range("J2")) Is Nothing Then
Sheet8.ListObjects("Table2").Range.AutoFilter Field:=15, Criteria1:=Sheet2.Range("J2").Value
End If
End Sub
Right now, this code works, but only if I manually change value in J2.