|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Option Explicit
Sub TEST()
Dim ar(1 To 14, 1 To 3), br, i&, j&, m&, n&, k&, iColor&, t#
DoApp False
t = Timer
Cells.Interior.ColorIndex = 0
For i = 1 To UBound(ar)
Set ar(i, 2) = CreateObject("Scripting.Dictionary")
Set ar(i, 3) = Cells(8, (i - 1) * 9 + 2).Resize(29993).Resize(, 5)
ar(i, 1) = ar(i, 3)
For m = 1 To UBound(ar(i, 1))
For n = 1 To UBound(ar(i, 1), 2)
ar(i, 2)(ar(i, 1)(m, n)) = ""
Next n
Next m
Next i
br = Sheets(2).[A1].CurrentRegion
For i = 2 To UBound(br)
k = 0
For j = 1 To UBound(ar)
If ar(j, 2).exists(br(i, 1)) Then
k = k + 1
End If
Next j
If k > 0 And k <> br(i, 2) Then
iColor = IIf(k > br(i, 2), 3, 47)
For j = 1 To UBound(ar)
For m = 1 To UBound(ar(i, 1))
For n = 1 To UBound(ar(i, 1), 2)
If ar(j, 1)(m, n) = br(i, 1) Then
ar(j, 3)(m, n).Interior.ColorIndex = iColor
End If
Next n
Next m
Next j
End If
Next i
DoApp
MsgBox "执行完毕!_用时: " & Format(Timer - t, "0.00") & " 秒", 64
End Sub
Function DoApp(Optional b As Boolean = True)
With Application
.ScreenUpdating = b
.DisplayAlerts = b
.Calculation = -b * 30 - 4135
End With
End Function |
评分
-
1
查看全部评分
-
|