本帖最后由 gdfcx 于 2019-6-14 22:10 编辑
- Sub macro()
- Dim arr, brr(), i%, k%, j%
- arr = Sheet1.[a1].CurrentRegion
- ReDim brr(1 To UBound(arr) * 184, 1 To 21)
- For i = 2 To UBound(arr)
- For j = 0 To 183
- k = k + 1
- brr(k, 1) = "A"
- brr(k, 2) = "SubNetwork=" & arr(i, 1) & ",MEID=" & arr(i, 2) & ",ENBFunctionTDD=" & arr(i, 3) & ",SratgMapiIMEISVTDD=" & j
- brr(k, 3) = arr(i, 1)
- brr(k, 4) = arr(i, 2)
- brr(k, 5) = arr(i, 3)
- brr(k, 6) = j
- brr(k, 7) = "SratgMapiIMEISVTDD=" & j
- brr(k, 8) = "35714304"
- brr(k, 9) = 460
- brr(k, 10) = "00"
- brr(k, 11) = 0
- brr(k, 12) = 99
- brr(k, 13) = 0
- brr(k, 14) = 99
- brr(k, 15) = "SubNetwork=" & arr(i, 1) & ",MEID=" & arr(i, 2) & ",ENBFunctionTDD=" & arr(i, 3) & ",HoProfIMEISVTDD=0"
- brr(k, 16) = ""
- brr(k, 17) = ""
- brr(k, 18) = 0
- brr(k, 19) = 1
- brr(k, 20) = 0
- brr(k, 21) = 1
- Next j
- Next i
- Sheet2.Select
- Sheet2.UsedRange.Offset(2).ClearContents
- Sheet2.[a3].Resize(k, 21) = brr
- End Sub
复制代码
|