|
楼主 |
发表于 2017-5-12 10:09
|
显示全部楼层
本帖最后由 wwj804 于 2017-5-12 10:12 编辑
你好老师,我想把二组代码整合在一起,可是不会做,怎样做?
代码1:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim a
If Target.Row <> 2 Then
Exit Sub
Else
a = Target.Column
Sheets("汇总").Cells(a - 7, 5) = Target
End If
End Sub
代码2:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 3 Or Target.Column <> 5 Or Target.Count > 1 Then Exit Sub
Application.EnableEvents = False
If Len(Target) = 0 Then Target.EntireRow = ""
arr = Sheet8.[a1].CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(arr)
d(CStr(arr(i, 1))) = i
Next
i = d(CStr(Target.Value))
If i > 0 Then
Target.Offset(, 1) = arr(i, 4)
Target.Offset(, 2) = arr(i, 9)
End If
Application.EnableEvents = True
End Sub
|
|