|
发表于 2014-1-26 18:10
|
显示全部楼层
本楼为最佳答案
15楼的条件也加进去了,代码请测试- Sub bbb2()
- Dim arr, arr1, i&, j&, n&, s$, k&
- arr = Application.Transpose(Range("EU3:EW12"))
- arr1 = [ep1]
- If Not IsArray(arr1) Then k = 1 Else k = UBound(arr1, 2)
- For j = 1 To 3
- s = Join(Application.Index(arr, j, 0), "")
- For i = 1 To k
- If k = 1 Then
- If n < InStr(s, Mid(arr1, j, 1)) Then n = InStr(s, Mid(arr1, j, 1))
- Else
- If n < InStr(s, Mid(arr1(1, i), j, 1)) Then n = InStr(s, Mid(arr1(1, i), j, 1))
- End If
- Next i
- Next j
- If n = 10 Then [eu3:ew5].Interior.ColorIndex = 37: Exit Sub
- Range(Cells(n + 3, "eu"), Cells(UBound(arr, 2) + 2, "ew")).Interior.ColorIndex = 37
- End Sub
复制代码 |
|