Sub 替换()
Dim rg As Range
For Each rg In Selection
Dim t As Boolean
t = Application.WorksheetFunction.IsNumber(rg)
If t = True And rg.Value > 0 Then rg.Value = "正数"
Next rg
End Sub
Sub 一次选取所在行()
Dim rg As Range
Dim t As Boolean
For Each rg In Range("a2:c12")
t = Application.WorksheetFunction.IsNumber(rg)
If t = True And rg.Value > 0 Then rg.EntireRow.Select
Next rg
End Sub
'为什么只能选取一行,明明循环选取行了啊