|
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Count > 1 Or Target.Column <> 6 Then Exit Sub
- Dim arr, i%
- Application.EnableEvents = False
- arr = Range("b2", Cells(Rows.Count, 3).End(3))
- For i = LBound(arr) To UBound(arr)
- If arr(i, 1) = Target.Value Then Target.Value = arr(i, 2): GoTo 100
- If arr(i, 2) = Target.Value Then GoTo 100
- Next
- Target.Value = Target.Value & "无"
- 100:
- Application.EnableEvents = True
- End Sub
复制代码 |
|