|
Sub sjs()
Dim d, e, f, g, h, i, j, k, l, m, n
Do
d = Int(Rnd * 11) + 25
e = Int(Rnd * 9) + 20
f = Int(Rnd * 25) + 70
g = Int(Rnd * 15) + 68
h = Int(Rnd * 20) + 165
i = Int(Rnd * 16) + 160
j = Int(Rnd * 14) + 35
k = Int(Rnd * 12) + 32
l = Int(Rnd * 20) + 170
m = Int(Rnd * 15) + 166
t = (l + 2 * h - 2 * f - j) + (m + 2 * i - 2 * g - k) - 18
If t <= 545 And t >= 489 Then
n = 13
n = n + 1
Cells(n, 4) = d
Cells(n, 5) = e
Cells(n, 6) = f
Cells(n, 7) = g
Cells(n, 8) = h
Cells(n, 9) = i
Cells(n, 10) = j
Cells(n, 11) = k
Cells(n, 12) = l
Cells(n, 13) = m
Cells(n, 20) = t
End If
Loop While n <> 14
MsgBox "OK!"
End Sub
随机数全填到第14行的。。。4列到13列,和20列
请高手老师们用,VBA写一个代码,将符合条件的随机数,赋值到相应的单元格中。。。万分感谢。。
[ 本帖最后由 idliyi 于 2009-6-29 16:24 编辑 ] |
|