Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 And Target.Row > 4 Then Cells(Target.Row, 4) = Cells(Target.Row, 4) + 1
If Target.Row >= 5 And Target.Row <= 101 And _
Target.Column = 6 Then
Application.EnableEvents = False
Cells(Target.Row, 2) = Now()
Application.EnableEvents = True
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 And Target.Row > 4 Then Cells(Target.Row, 4) = Cells(Target.Row, 4) + 1
If Target.Row >= 5 And Target.Row <= 101 And _
Target.Column = 6 Then
Application.EnableEvents = False
Cells(Target.Row, 2) = Now()
Application.EnableEvents = True
End If
End Sub