加2段语句:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 2 And Target.Count = 1 Then
If (Target.Column - 2) Mod 5 = 0 And Target.Value <> "" Then
Application.EnableEvents = False
Dim y%, arr
'..............
End If
Application.EnableEvents = True
End Sub
加2段语句:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 2 And Target.Count = 1 Then
If (Target.Column - 2) Mod 5 = 0 And Target.Value <> "" Then
Application.EnableEvents = False
Dim y%, arr
'..............
End If
Application.EnableEvents = True
End Sub