|
发表于 2013-12-24 16:46
|
显示全部楼层
本楼为最佳答案
dfshm 发表于 2013-12-24 16:30
老师您好,谢谢帮助。需要一个代码,要把代码粘到其它工作薄中,您写的程序好象有两层。
能把代码贴出 ...
可以只用模块一的代码就可以了。- Sub 标色()
- Dim i&, j As Byte, k As Byte, m%
- Dim sh As Worksheet, r&, c&
- For j = 2 To Sheets.Count
- With Sheets(j)
- r = .Range("a" & Rows.Count).End(3).CurrentRegion.Rows.Count + .Range("a" & Rows.Count).End(3).CurrentRegion.Row - 1
- c = .Range("a" & Rows.Count).End(3).CurrentRegion.Columns.Count + .Range("a" & Rows.Count).End(3).CurrentRegion.Column - 1
- For i = 1 To r
- If .Range("a" & i).Interior.ColorIndex = xlNone Then
-
- For n = 1 To r
- For k = 2 To c
- If .Cells(n, k).Interior.ColorIndex = 3 Then
- .Cells(n, 1).Interior.ColorIndex = 6
- GoTo 100
- End If
- Next k
- 100:
- Next n
- End If
- Next i
- End With
- Next j
- End Sub
复制代码 |
评分
-
查看全部评分
|