|
各位大神,
想实现下图效果,我自己也写了一段代码可以实现,但是,数据多了就有点慢,看能不能优化。请赐教!
Sub 快速填色()
Dim i, m, k
i = 2
m = 0
Do While Cells(i, 1) <> ""
If Cells(i, 1) <> Cells(i - 1, 1) Then
m = m + 1
Else
m = m
End If
k = m Mod 2
If k = 1 Then
Range("A" & i & ":" & "W" & i).Interior.ThemeColor = xlThemeColorAccent4
Range("A" & i & ":" & "W" & i).Interior.TintAndShade = 0.799981688894314
Else
Range("A" & i & ":" & "W" & i).Interior.ThemeColor = xlThemeColorAccent6
Range("A" & i & ":" & "W" & i).Interior.TintAndShade = 0.799981688894314
End If
i = i + 1
Loop
End Sub
|
|