|
试试这个,以前做过一次!
- Sub cc()
- Dim Hx As Integer, X As Integer, Js As Byte
- Dim Arr, Brr(1 To 10000, 1 To 3) As String
- Hx = Range("A65536").End(xlUp).Row
- Arr = Range("A1:C" & Hx)
- For Hx = 2 To UBound(Arr)
- Js = 1
- X = X + 1
- Brr(X, 1) = Arr(Hx, 1)
- Brr(X, 2) = Split(Arr(Hx, 2), "-")(0)
- Brr(X, 3) = Arr(Hx, 3)
- Do Until Js >= Arr(Hx, 3)
- X = X + 1
- Brr(X, 2) = "00" & Split(Arr(Hx, 2), "-")(0) + Js
- Js = Js + 1
- Loop
- Next
- Range("E2:G1000").ClearContents
- Range("E2").Resize(X, 3) = Brr
- End Sub
复制代码
|
|