|
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Count > 1 Then Exit Sub
- Application.EnableEvents = False
- Dim rng As Range
- If Target.Column = 2 Then
- If Target.Value = "" Then Target(1, 2) = "": Exit Sub
- Set rng = Sheet5.Columns(1).Find(Target)
- If Not rng Is Nothing Then Target(1, 2) = rng(1, 2)
- ElseIf Target.Column = 3 Then
- If Target <> "" Then
- With Sheet5
- Set rng = .Columns(1).Find(Target.Offset(, -1))
- If rng Is Nothing Then
- .[a65536].End(3).Offset(1) = Target.Offset(, -1)
- .[b65536].End(3).Offset(1) = Target
- End If
- End With
- End If
- End If
- Application.EnableEvents = True
- End Sub
复制代码 |
|