|
- Sub tt()
- x1 = [a2]: nmin = Val([b2]): nmax = Val(Split([b2], "-")(1))
- res = qs(x1, nmin, nmax): l1 = Len(res)
- x2 = [a3]: nmin = Val([b3]): nmax = Val(Split([b3], "-")(1))
- If Len(res) + nmin < 3 Then nmin = 3 - Len(res)
- res = res & qs(x2, nmin, nmax)
- r = [a65536].End(3).Row + 1
- Cells(r, 1) = res: Cells(r, 2) = l1: Cells(r, 3) = Len(res) - l1
- End Sub
- Function qs(xstr, nmin, nmax) '随机取数(字符串,最小个数,最大个数)
- Dim L%
- p = Int(Rnd * (nmax - nmin + 1) + nmin)
- If p = 0 Then qs = "": Exit Function
- L = Len(xstr)
- For i = 1 To p
- pp = Int(Rnd * L + 1)
- qs = qs & Mid(xstr, pp, 1)
- Mid(xstr, pp, 1) = Mid(xstr, L, 1)
- L = L - 1
- Next
- End Function
复制代码 |
|