|
本帖最后由 LZH02620 于 2019-6-27 14:21 编辑
Sub test() '将指定区域内相同单元格字体红粗
Dim d, i, j, k, arr, brr, crr, t
Set d = CreateObject("scripting.dictionary")
arr = Range("e3:fd10000")
t = Timer
For i = 1 To 9998
For j = 1 To 156
If arr(i, j) <> "" Then d(arr(i, j)) = d(arr(i, j)) + 1
Next
Next
brr = WorksheetFunction.Transpose(d.keys)
crr = WorksheetFunction.Transpose(d.items)
For k = 1 To d.Count
If crr(k, 1) > 1 Then
For i = 3 To 10000
For j = 5 To 161
If brr(k, 1) = Cells(i, j) Then
Cells(i, j).Font.ColorIndex = 3
Cells(i, j).Font.Bold = True
End If
Next
Next
End If
Next
MsgBox ("用时" & Timer - t & "秒")
End Sub
|
|