我看到第11题 gycstudy 同学(http://www.excelpx.com/thread-308553-1-2.html)是这么写的
Sub 习题2()
Dim rg As Range
Dim n As Integer
n = 0
For Each c In Range("A2:C12")
If (VBA.IsNumeric(c) = True And c.Value > 0) Then
n = n + 1
If n = 1 Then Set rg = c.EntireRow
Set rg = Union(rg, c.EntireRow)
End If
Next c
rg.Select
End Sub
而我却想移动一下n=0的位置,写成这样
For Each c In Range("A2:C12")
n = 0
If (VBA.IsNumeric(c) = True And c.Value > 0) Then
n = n + 1
(我只有这段和他不一样,其他的地方我倒是认同)