第1个回答 2023-10-14
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub '多于1个单元格时直接退出sub
If Not Intersect(Target, Range("A1:A5")) Is Nothing Then
Call 宏1
ElseIf Not Intersect(Target, Range("A6:A10")) Is Nothing Then
Call 宏2
End If
End Sub