|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Count > 1 Then Exit Sub
- If Target = "" Then Exit Sub
- If Target.Row < 4 Then Exit Sub
- Dim rng As Range, n&
- n = Target.Column
- If n <> 12 And n <> 13 Then Exit Sub
- Set rng = Sheets("DATA").Columns(n - 11).Find(Target, lookat:=n - 11)
- Application.EnableEvents = False
- If Not rng Is Nothing Then
- Cells(Target.Row, 12).Resize(, 2) = Sheets("DATA").Cells(rng.Row, 1).Resize(, 2).Value
- Else
- Cells(Target.Row, 12).Resize(, 2) = Array(0, "Input Error!")
- End If
- Application.EnableEvents = True
- End Sub
复制代码 |
评分
-
2
查看全部评分
-
|