VBA代码1:
Sub MXG825()
Dim X%, Y%
Randomize
Do
For X = 1 To 10
For Y = 1 To 3
Cells(X, Y) = Int(Rnd * 30 - 15)
If Application.Sum(Range("A1:C10")) = 0 Then End
Next Y
Next X
Loop
End Sub
VBA代码2:
Sub MXG825()
Dim X%, Y%
Randomize
Do
X = Int(Rnd * 10 + 1)
Y = Int(Rnd * 3 + 1)
Cells(X, Y) = Int(Rnd * 30 - 15)
If Application.Sum(Range("A1:C10")) = 0 Then End
Loop
End Sub