Excel VBA keeps crashing after looping for less than 300 rows

I'm currently working on Excel VBA for the first time and I'm having some trouble getting the code below to not crash after looping for about 280 rows. The goal is to have the cells in Sheet1 that have the same previous column as the cells in Sheet2 to update each time we make a change (and vice versa). The code below is for Sheet1, the code for Sheet2 is identical except for the Worksheets() object.

I was testing this on a smaller Excel workbook and it was working with no issues on either worksheets however going into the actual Excel I want to update is crashing Excel with the Error:
-2147417848 (80010108): Method 'Value' of Object 'Range' Failed.

Here's what I tried:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim counter As Integer
    For counter = 10 To 290
        If Worksheets("Sheet2").Cells(counter, 6).Value = Target.Offset(0, -1).Value Then
            Worksheets("Sheet2").Cells(counter, 7).Value = Target.Value
        End If
    Next counter
End Sub```

For the sheet 2, the code is the following:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim counter As Integer
    For counter = 19 To 66
        If Worksheets("Sheet1").Cells(counter, 6).Value = Target.Offset(0, -1).Value Then
            Worksheets("Sheet1").Cells(counter, 7).Value = Target.Value
        End If
    Next counter
End Sub```

Any help is greatly appreciated, thank you in advance!

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rg As Range: Dim counter As Integer
Application.EnableEvents = False
Set rg = Range("G10:G290")
    If Not Intersect(Target, rg) Is Nothing Then
        For counter = 10 To 290
            If Sheets("Sheet2").Cells(counter, 6).Value = Target.Offset(0, -1).Value Then
                Sheets("Sheet2").Cells(counter, 7).Value = Target.Value
            End If
        Next
    End If
Application.EnableEvents = True
End Sub

the rg is to restrict the area of the cell which is changed.
So, if the cell changed is outside G10:G290, it won't trigger the loop.

And it should have the application.enableevents=false in the beginning and set it back to true ---> application.enableevents=true just before the end sub to avoid the sheet_change sub in another sheet module is triggered.

FYI, this kind of code will work something like this :<br>
Say, in sheet1 and sheeet2 cell F15,F20 and F25 value is "A".<br>
And in sheet1 and sheeet2 cell G15 value = 1, G20 = 2, G25 = 3.<br>

In sheet1 cell G20, a user type 7.<br>
Result in sheet2 cell G15, G20 and G25 value is 7, <br>
but in sheet1 cell G15 value is still 1 and cell G25 value is still 3.

Later on, another user type 100 in sheet2 cell G25.<br>
Result in sheet1 cell G15, G20 and G25 value is 100, <br>
but in sheet2 cell G15 and cell G20 value is still 7.

Is that your expected result ?