|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
文件另存为xlsm格式 总列数超过256了
Sub color()
Dim isNUM As Boolean
Dim c, r, i, j As Integer
rr = Range("A65536").End(xlUp).Row
Range("A2:A" & rr).Select
i = 1
j = 1
For r = 1 To Selection.Rows.Count Step 1
For c = 3 To 171 'Selection.Columns.Count Step 1
If Selection.Cells(r, c).Text = Selection.Cells(r, c - 1).Text Then
i = i + 1
Else
Cells(Selection.Cells(r, c).Row, 171 + j).Value = i
i = 1
j = j + 1
End If
Selection.Cells(r, c).Interior.ColorIndex = i
Next c
Cells(Selection.Cells(r, c).Row, 171 + j).Value = i
i = 1
j = 1
Next r
End Sub
|
评分
-
1
查看全部评分
-
|