|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Option Explicit
Sub TEST2()
Dim ar, br, i&, j&, k&, isFlag As Boolean
Application.ScreenUpdating = False
ar = [A11:C15].Value
For i = 1 To UBound(ar)
ar(i, 1) = "," & Join(Application.Index(ar, i), ",") & ","
Next i
With [E1].CurrentRegion
br = .Value
.Interior.Color = xlNone
For j = 1 To UBound(br, 2)
For i = 1 To UBound(br) - UBound(ar) + 1
isFlag = True
For k = 0 To UBound(ar) - 1
If InStr(ar(k + 1, 1), br(i + k, j)) = False Then
isFlag = False: Exit For
End If
Next k
If isFlag Then
.Cells(i, j).Resize(UBound(ar)).Interior.Color = vbGreen
End If
Next i
Next j
End With
Application.ScreenUpdating = True
Beep
End Sub
|
评分
-
2
查看全部评分
-
|