eking_tang 发表于 2014-10-14 11:36
抱歉让疯版误会了~~我Sheet1到Sheet100XXX还是要检查的.
只是针对"新增資料"工作表,让代码忽略对"新增資 ...
Sub zz()
Dim sh As Worksheet
For Each sh In Worksheets
With sh
If sh.Name <> "新增資料" Then
For j = 2 To .UsedRange.Columns.Count
.Range(.Cells(28, j), .Cells(29, j)).Interior.ColorIndex = _
IIf(.Cells(28, j) = .Cells(29, j), 8, 3)
Next
End If
End With
Next
End Sub