题目是蓝版第11讲的题目:要求选定一个区域,执行宏后,选定的是以前选定的区域中所有大于0的数字的行
Sub 选取所在行()
Dim rg As Range, rg1 As Range, i As Byte
For Each rg In Selection
If Application.WorksheetFunction.IsNumber(rg) = True And rg > 0 Then
i = i + 1
If i = 1 Then rg1 = rg
Else: Set rg1 = Union(rg1, rg)
End If
End If
Next
rg1.EntireRow.Select
End Sub
运行后,显示:end if没有if块,这是咋回事啊,我两个if语句不都有end if吗?请高手指导!