|
是这个意思吗?
Sub 矩形圆角1_Click()
Set d = CreateObject("scripting.dictionary")
For i = 2 To [H1].End(xlDown).Row
For j = 1 To Cells(i, "J").Value
a1 = Mid("0123456789ABCDEF", Int(Rnd * 16 + 1), 1)
a2 = Mid("0123456789ABCDEF", Int(Rnd * 16 + 1), 1)
a3 = Mid("0123456789ABCDEF", Int(Rnd * 16 + 1), 1)
If d.Count > 2000 Then d.RemoveAll
Do While d.exists(a1 & a2 & a3)
a1 = Mid("0123456789ABCDEF", Int(Rnd * 16 + 1), 1)
a2 = Mid("0123456789ABCDEF", Int(Rnd * 16 + 1), 1)
a3 = Mid("0123456789ABCDEF", Int(Rnd * 16 + 1), 1)
Loop
d(a1 & a2 & a3) = a1 & a2 & a3
row1 = Application.CountA(Range("a:a")) + 1
Cells(row1, "A") = Cells(i, "H")
Cells(row1, "B") = Cells(i, "I") & a1 & a2 & a3
Cells(row1, "C") = a1 & ".bmp"
Cells(row1, "D") = a2 & ".bmp"
Cells(row1, "E") = a3 & ".bmp"
Next j
Next i
Set d = Nothing
End Sub
|
|