|
- Sub kj()
- Dim arr, brr
- Application.ScreenUpdating = False
- Set Sh1 = ActiveSheet
- With Sh1
- arr = .Range("a1:b" & .Cells(.Rows.Count, 1).End(3).Row)
- End With
- ReDim brr(1 To 100000, 1 To 1)
- For i = 1 To UBound(arr)
- If arr(i, 1) <> "" Then
- For j = 1 To arr(i, 2)
- m = m + 1
- brr(m, 1) = arr(i, 1)
- Next
- Else
- m = m + 1
- brr(m, 1) = arr(i, 1)
- End If
- Next
- With Sh1
- .Range("d1:d" & .Rows.Count).ClearContents
- .Range("d1").Resize(m, 1) = brr
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|