|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 一把小刀闯天下 于 2019-9-17 12:09 编辑
'重复的连在一起了,,,
'增加了匹配成功后行变色
Option Explicit
Sub test()
Dim arr, i As Long, j As Long, dic, t As String
Set dic = CreateObject("scripting.dictionary")
Application.ScreenUpdating = False
Sheets("sheet1").Activate
[a:f].Interior.ColorIndex = xlNone
arr = Sheets("结果").[a1].CurrentRegion.Resize(, 2)
For i = 1 To UBound(arr, 1)
t = Trim(arr(i, 1))
dic(t) = dic(t) & "," & arr(i, 2)
Next
arr = [a1].CurrentRegion.Resize(, 5)
ReDim brr(1 To UBound(arr, 1), 1 To 1)
For i = 1 To UBound(arr, 1)
t = vbNullString
For j = 1 To UBound(arr, 2)
t = t & Space(1) & arr(i, j)
Next
t = Mid(t, 2)
If dic.exists(t) Then
brr(i, 1) = Mid(dic(t), 2)
Cells(i, 1).Resize(, 6).Interior.Color = vbYellow
End If
Next
[f1].Resize(UBound(brr, 1)) = brr
Application.ScreenUpdating = true
End Sub
|
评分
-
4
查看全部评分
-
|