- Sub 增加()
- Dim Arr, Brr, Tmp, Str
- Arr = [a1].CurrentRegion
- ReDim Brr(1 To Arr(2, 1), 1 To UBound(Arr, 2))
- Tmp = Right(Arr(2, 3), 3)
- Str = Replace(Arr(2, 3), Tmp, "")
- For i = 1 To Arr(2, 1)
- Brr(i, 1) = Arr(2, 1)
- Brr(i, 2) = Arr(2, 2)
- Brr(i, 3) = Str & Format(Tmp + i - 1, "000")
-
- For j = 4 To UBound(Arr, 2)
- Brr(i, j) = Arr(2, j)
- Next
- Next
- [a4].Resize(Arr(2, 1), UBound(Arr, 2)) = Brr
- End Sub
复制代码
大致这样的效果,你自己在修改一下。
|