Sub demo()
[a2:H10000].ClearContents
b = Range("j2:r" & [r2].End(4).Row)
r = 1
For i = 1 To UBound(b)
If b(i, 9) > 0 Then
For j = 1 To b(i, 9)
r = r + 1
For k = 1 To 8
Cells(r, k) = b(i, k)
Next
Next
End If
Next
End Sub
Sub demo()
[a2:H10000].ClearContents
b = Range("j2:r" & [r2].End(4).Row)
r = 1
For i = 1 To UBound(b)
If b(i, 9) > 0 Then
For j = 1 To b(i, 9)
r = r + 1
For k = 1 To 8
Cells(r, k) = b(i, k)
Next
Next
End If
Next
End Sub
[r2].End(4).Row-----取值到合计3549,row等于24,不需要循环到这行。
b(i, 9) > 0 ------空单元格为假空,所以判断的时候是大于零,所以循环出错。
Sub demo()
[a2:H10000].ClearContents
b = Range("j2:r" & [j2].End(4).Row)
r = 1
For i = 1 To UBound(b)
If b(i, 9) <> "" Then
For j = 1 To b(i, 9)
r = r + 1
For k = 1 To 8
Cells(r, k) = b(i, k)
Next
Next
End If
Next
End Sub