|
1学分
我想判断,B和D:K这几个单元格之间是否有重复的数据,如果有,就在重复的上面显示红色.一行一行的判断,列数最多是20列,但是C列肯定是不参与判断的.就是隔着一个C列.
请问一下这个代码应该怎么写啊?
Sub demo()
arr = [b1].CurrentRegion
For i = 1 To UBound(arr)
ReDim v(1 To 99)
For k = 1 To UBound(arr, 2)
If k <> 2 And arr(i, k) Then v(arr(i, k)) = v(arr(i, k)) + 1
Next
For k = 1 To UBound(arr, 2)
If k <> 2 And arr(i, k) Then
If v(arr(i, k)) > 1 Then Cells(i, k + 1).Interior.ColorIndex = 22
End If
Next
Next
End Sub
祝順心,南無阿彌陀佛!
|
最佳答案
查看完整内容
Sub demo()
arr = .CurrentRegion
For i = 1 To UBound(arr)
ReDim v(1 To 99)
For k = 1 To UBound(arr, 2)
If k 2 And arr(i, k) Then v(arr(i, k)) = v(arr(i, k)) + 1
Next
For k = 1 To UBound(arr, 2)
If k 2 And arr(i, k) Then
If v(arr(i, k)) > 1 Then Cells(i, k + 1).Interior.ColorIndex = 22
End If
Next
Next
End ...
|