|
楼主 |
发表于 2015-12-21 14:21
|
显示全部楼层
zjdh 发表于 2015-12-21 13:49
谢谢老师了,真的不错。高!(I,A)和(I,"A")就是不同,你太有才和细心了。谢谢了。不过还有个问题问问,不知道也能不能帮忙。谢谢了。
R = Sheet3.Cells(Rows.Count, 1).End(xlUp).Row
If t.Address = "$G$9" Then
A = Sheet3.Range("a4" & ":d" & R).Find(t.Value).Column
Application.EnableEvents = False
For i = 1 To Sheet3.Cells(65536, A).End(xlUp).Row
If Sheet3.Cells(i, "A") = t.Value Then
Cells(9 + N, "H") = Sheet3.Cells(i, "a") & "页(" & Sheet3.Cells(i, "D") & ")": N = N + 1
End If
Application.EnableEvents = True
Next
End If
If t.Address = "$I$9" Then
A = Sheet3.Range("a4" & ":d" & R).Find(t.Value).Column
Application.EnableEvents = False
For k = 4 To Sheet3.Cells(65536, A).End(3).Row
If Sheet3.Cells(k, "A") = t.Value Then
Cells(9 + N, "J") = Sheet3.Cells(k, "a") & "页(" & Sheet3.Cells(k, "D") & ")": N = N + 1
End If
Next
End If
Application.EnableEvents = True
上面的红色部分和绿色部份的代码看起来是有规律的和有点相同的,能不能把它优化简单点。谢谢了。
|
|