没搞出来,
不过
If Target.Column = 2 Then
''''
Else
If Target.Column = 3 Then
''''
可以写为:
If Target.Column = 2 Then
Debug.Print "B"
ElseIf Target.Column = 3 Then
Debug.Print "C"
End If
=================
或者
Select Case Target.Column
Case 2
Debug.Print "B"
Case 3
Debug.Print "C"
End Select