|
大家看下面这两段代码,区别就是红色部分,请问如果我用第一段代码,当x=10的时候,cells(10,1)="偶数", 然后又return到Next x...这时x会取11,我限制的x 是1 to 10,为啥会出现这种情况?(我a1:a10的单元格是1-10的数字)
Sub gh()
Dim x As Integer
For x = 1 To 10
If Cells(x, 1) Mod 2 = 0 Then GoSub 100
Next x
100:
Cells(x, 1) = "偶数"
Return
End Sub
Sub gh()
Dim x As Integer
For x = 1 To 10
If Cells(x, 1) Mod 2 = 0 Then GoSub 100
Next x
Exit sub
100:
Cells(x, 1) = "偶数"
Return
End Sub
|
|