用以下代码,注意单元名称的单元格格式为字符型,所以作为数字计算时会出错,所以需要改成数字格式。
- Private Sub CommandButton1_Click()
- Dim n&, s$, i&, j&, arr, brr, r&
- arr = [b11:c17]
- ReDim brr(1 To Application.Sum(Application.Index(arr, , 2)), 1 To 2)
- For i = 1 To UBound(arr)
- If arr(i, 1) > 0 Then
- n = arr(i, 2)
- s = arr(i, 1)
- For j = 1 To n
- r = r + 1
- brr(r, 1) = s
- brr(r, 2) = j
- Next j
- End If
- Next i
- [b19].Resize(r, 2) = brr
- End Sub
复制代码 |