Sub a()
Dim an As Range
For Each an In Range("t3:aa65536")
If an <> 0 And an <> "" Then
an.Interior.ColorIndex = 3
an.ClearContents
End If
Next an
End Sub
最后一个单元格最简单的方法,对运算不会有什么影响
Sub a()
Dim an As Range
For Each an In Range("t3:aa146")
If an <> 0 And an <> "" Then
an.Interior.ColorIndex = 3
an.ClearContents
End If
Next an
End Sub