Sub 题目1()
Dim rg As Range
Set rg = Selection
For Each ii In rg
If IsNumeric(ii) = True And ii.Value > 0 Then ii.Value = "正数"
Next ii
End Sub
Sub 题目2()
Dim rg As Range, rgg As Range
For Each rg In Range("A2:C12")
If IsNumeric(rg) = True And rg.Value > 0 Then
Set rgg = rg
Exit For
End If
Next
For Each rg In [A2:C12]
If IsNumeric(rg) = True And rg.Value > 0 Then
Set rgg = Union(rg, rgg)
End If
Next
rgg.EntireRow.Select