Sub 题目一()Dim rg As Range, rgs As RangeSet rgs = SelectionFor Each rg In rgs If IsNumeric(rg.Value) And rg.Value > 0 Then rg.Value = "正数"NextEnd SubSub 题目二()Dim rg As Range, rgs As RangeFor Each rg In Range("A2:C12") If Val(rg) > 0 Then Set rgs = rg Exit For End IfNextFor Each rg1 In Range("A2:C12") If Val(rg1) > 0 Then Set rgs = Union(rgs, rg1) End IfNextrgs.EntireRow.SelectEnd Sub