|
楼主 |
发表于 2017-5-30 08:26
|
显示全部楼层
这个代码不用index 如何改写吧
Sub test()
Dim a, b, c, d, e(1 To 5, 1 To 1), i%, j%, k%, m%
a = [a11].CurrentRegion
b = [h11].CurrentRegion
For i = 1 To 5
m = 0
c = Application.Transpose(Application.Index(b, i, 0))
d = Application.Transpose(Application.Index(a, i, 0))
For j = 1 To 6
For k = 1 To 6
If c(j, 1) = d(k, 1) Then m = m + 1
Next
Next
e(i, 1) = m
Next
[q11].Resize(5, 1) = e
End Sub
|
|