|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub d()
'VBA jimin
'QQ: 494585639
Dim arr(), brr(), Dic As Object
Set Dic = CreateObject("Scripting.Dictionary")
arr = Sheet2.Range("a1").CurrentRegion
brr = Sheet1.Range("g1:g" & Sheet1.Range("g65535").End(xlUp).Row)
For i = 1 To UBound(arr)
Dic(arr(i, 1)) = ""
Next
Sheet1.Columns("g:g").Interior.Pattern = xlNone
For i = 2 To UBound(brr)
If Dic.Exists(brr(i, 1)) Then
Range("g" & i).Interior.Color = 65535
End If
Next
End Sub |
评分
-
1
查看全部评分
-
|