|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub t()
- Dim i, j, d, dd
- Set d = CreateObject("Scripting.Dictionary")
- Set dd = CreateObject("Scripting.Dictionary")
- For j = 1 To 10
- 0: d.RemoveAll
- Do
- d(WorksheetFunction.RandBetween(1, 14)) = ""
- If d.Count = 4 Then Exit Do
- Loop
- If Not dd.Exists(d.keys()(0) & d.keys()(1) & d.keys()(2) & d.keys()(3)) Then
- dd(d.keys()(0) & d.keys()(1) & d.keys()(2) & d.keys()(3)) = ""
- pth = ThisWorkbook.Path
- Open pth & "" & j & ".txt" For Output As #1
- For i = 0 To 3
- Print #1, i + 1&; "、" & Range("a" & d.keys()(i))
- Next
- Close #1
- Else
- GoTo 0
- End If
- Next j
- End Sub
复制代码 |
|