Is Calculate needed instead of Change?

[breakbacktennis]

Hi, Im looking for this code to work on a live feed. It currently works when In-play is manually typed but not when linked with a feed that will fill the cell with In-play. Do i need a worksheet calculate instead of change for this to work. Regards

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim KeyCells As Range




   If Target.Address <> Range("G1").Address Then Exit Sub
    


        If Range("G1").Value = "In-play" Then
               Range("U9").Value = Range("G9").Value
               Range("U11").Value = Range("G11").Value
        End If


End Sub

 

[breakbacktennis]

Desperately struggling with this if anyone has any ideas.