新人学习。 答题1:
Sub Sheet4_按钮1_Click()
On Error Resume Next
Dim rg As Range
For Each rg In Selection
If IsNumeric(rg) And rg.Value > 0 Then
rg = "正数"
End If
Next rg
End Sub
答题2:
Sub dd()
Dim rng As Range, rg As Range
For Each rng In Range("B11", "F19")
If IsNumeric(rng) And rng.Value > 0 Then
If rg Is Nothing Then Set rg = rng
Set rg = Union(rg, rng)
End If
Next rng
rg.EntireRow.Select
End Sub