点击文件名下载附件
[求助] 随机号码组的生成
Sub suiji() Dim d As Object, arr1(1 To 49), ARR2(1 To 49) Set d = CreateObject("scripting.dictionary") Do K = Int(Rnd() * 33 + 1) d(K) = "" Loop Until d.Count = 33 ARR = d.keys SR = Join(Array(1, 2, 3, 8, 9, 14, 15, 20, 21, 26, 27, 32, 33, 38, 39, 44, 45, 46), "-") For X = 1 To 49 If InStr(SR, "-" & X & "-") > 0 Then arr1(X) = "" Else R = R + 1 arr1(X) = ARR(R - 1) End If Next X Sheets("表1").Range("k5").Resize(1, 49) = arr1 End Sub
点击文件名下载附件
[求助] 随机号码组的生成
Sub suiji() Dim d As Object, arr1(1 To 49), ARR2(1 To 49) Set d = CreateObject("scripting.dictionary") Do K = Int(Rnd() * 33 + 1) d(K) = "" Loop Until d.Count = 33 ARR = d.keys SR = Join(Array(1, 2, 3, 8, 9, 14, 15, 20, 21, 26, 27, 32, 33, 38, 39, 44, 45, 46), "-") For X = 1 To 49 If InStr(SR, "-" & X & "-") > 0 Then arr1(X) = "" Else R = R + 1 arr1(X) = ARR(R - 1) End If Next X Sheets("表1").Range("k5").Resize(1, 49) = arr1 End Sub