|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count <> 1 Then Exit Sub
If Target.Column <> 1 Then Exit Sub
If Target.Row = 1 Then Exit Sub
If Len(Target) <> 4 Then Exit Sub
if target.value >=700 the exit sub
With Sheets("m")
Set Rng = .Columns(1).Find(Target.Value, lookat:=xlWhole)
If Not Rng Is Nothing Then
Application.EnableEvents = False
Cells(Target.Row, 2) = Rng.Offset(0, 1)
Cells(Target.Row, 3) = Rng.Offset(0, 3)
Cells(Target.Row, 4) = Rng.Offset(0, 5)
Application.EnableEvents = True
End If
End With
End Sub |
评分
-
1
查看全部评分
-
|