|
发表于 2012-1-15 09:23
|
显示全部楼层
本楼为最佳答案
本帖最后由 sunjing-zxl 于 2012-1-15 09:24 编辑
- Sub aa()
- Dim arr, arr1, arr2, arr3
- Dim i As Long, j As Long
- Dim n As Long, m As Long
- arr = Range("B3:B" & [A65536].End(xlUp).Row)
- arr1 = Range("H3:H" & [A65536].End(xlUp).Row)
- arr2 = Range("HA1:HJ" & [HA65536].End(xlUp).Row)
- ReDim arr3(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- n = 0
- For j = 2 To UBound(arr2)
- If arr2(j, arr1(i, 1) + 1) = arr(i, 1) Then
- n = n + 1
- arr3(i, 1) = "OK"
- Exit For
- End If
- Next j
- If n = 0 Then
- arr3(i, 1) = "●"
- End If
- Next i
- Range("J3:J" & [J65536].End(xlUp).Row + 3).ClearContents
- Range("J3").Resize(UBound(arr3), 1) = arr3
- End Sub
复制代码 附件:
Book1-sunjing.rar
(29.58 KB, 下载次数: 11)
|
评分
-
查看全部评分
|