|
本帖最后由 爱疯 于 2019-11-20 10:10 编辑
Sub abcde()
Dim a, b
For a = 2 To 100
For b = 3 To 100
If Cells(a, b) = "" Then
Cells(a, 2) = 7 - (Cells(1, 1) - Cells(a, b - 1))
a = a + 1
b = 3
Else
End If
If a > 60 Then
Exit Sub
End If
Next b
Next
End Sub
如果将第6条语句这样写,就不报错。
Cells(a, 2) = (Cells(1, 1) - Cells(a, b - 1))-7
为什么?
|
|