|
- Sub ttt() '数组法
- [a2:e10000].Interior.ColorIndex = 0
- arr = [a1].CurrentRegion
- For i = 2 To UBound(arr) - 1
- x = arr(i, 1) & arr(i, 2) & arr(i, 3) & arr(i, 4) & arr(i, 5)
- For ii = i + 1 To UBound(arr)
- xx = arr(ii, 1) & arr(ii, 2) & arr(ii, 3) & arr(ii, 4) & arr(ii, 5)
- If x = xx Then xstr = xstr & "," & Cells(i, 1).Resize(1, 5).Address(0, 0) & "," & Cells(ii, 1).Resize(1, 5).Address(0, 0)
- Next
- Next
- xstr = Mid(xstr, 2)
- If Len(xstr) > 0 Then Range(xstr).Interior.ColorIndex = 3
- End Sub
复制代码 |
评分
-
查看全部评分
|