各位老师好:
我这边有一组代码,想达到这样一个目的:就是想把工作表中的大于0的数字替换成字符"正数“,但是程序编完了后,却不能执行,也没提示出错,这是为什么呢?
代码如下:
On Error Resume Next
Range("a1:c11").Select
Dim rg As Range
For Each rg In Range("a1:c11").Select
If rg > 0 Then
rg = "正数"
End If
Next rg
On Error Resume Next
'Range("a1:c11").Select
Dim rg As Range
For Each rg In Range("a1:c11")'.Select
If rg > 0 Then
rg = "正数"
End If
Next ‘RG 可省略
’删除红色部分!
On Error Resume Next
'Range("a1:c11").Select
Dim rg As Range
For Each rg In Range("a1:c11")'.Select
If rg > 0 Then
rg = "正数"
End If
Next ‘RG 可省略
’删除红色部分!