|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
试试看:
- Sub test()
- arr = [A1].CurrentRegion
- For i = 1 To UBound(arr)
- Set d = CreateObject("Scripting.Dictionary")
- For j = 1 To UBound(arr, 2)
- If arr(i, j) <> "" Then
- d(arr(i, j)) = 1
- End If
- Next
- If Cells(i, Columns.Count).End(xlToLeft).Column > UBound(arr, 2) Then
- t = Cells(i, Columns.Count).End(xlToLeft).Column
- Else
- t = UBound(arr) + 1
- End If
- brr = Range(Cells(1, UBound(arr) + 1), Cells(UBound(arr), t))
- For k = 1 To UBound(brr, 2)
- If d.exists(brr(i, k)) Then
- d(brr(i, k)) = 2
- End If
- Next
- crr = Range(Cells(1, 1), Cells(UBound(arr), t))
- For l = 1 To UBound(crr, 2)
- If d(crr(i, l)) = 2 Then
- Cells(i, l).Interior.ColorIndex = 3
- End If
- Next
- Set d = Nothing
- Next
- End Sub
复制代码 |
|