Worksheet change event code to display message box based on active cell offset content

[Nitefox]

I am trying to use the following Worksheet_Change event code to display a message box when the user types data in a G cell (within the range), and if the F cell on the row below contains "LAST ROW", but its not working:

If Not Intersect(Target, Range("G6:G200000")) Is Nothing Then
  For Each Rng In Intersect(Target, Range("G6:G200000"))
        If Rng.Offset(-1, -1).Value = "LAST ROW" Then
            Beep
            MsgBox "There are no more rows left. Please add more rows."
        End If
  Next Rng
End If