|
- Sub demo()
- Dim a As String, b As Integer, c As Integer, d As Integer, ar
- a = Range("c2").Value
- b = Val(Range("c4").Value)
- c = Val(Range("c5").Value)
- d = Range("c7").Value
- If c < b Or d < 1 Then MsgBox "起始截止数字错误": Exit Sub
- ReDim ar(1 To (c - b + 1) * d, 1 To 1)
- For i = b To c
- For j = 1 To d
- n = n + 1
- ar(n, 1) = a & Format(i, "0000")
- Next
- Next
- Sheets("自动生成的序列号").Range("a2").Resize(UBound(ar), 1) = ar
- End Sub
复制代码 附件楼下
|
|