本帖最后由 我行我速2008 于 2022-8-28 14:00 编辑
试试看,行不行。
Sub clear()
[i3:i1000].clear
End Sub
Sub tt()
clear
Dim ar, r, k
ar = [c1].CurrentRegion
For r = 2 To UBound(ar)
If ar(r, 1) <= 12 and ar(r,1) > 0 Then
For k = ar(r, 1) To 12
Cells(Rows.Count, 9).End(xlUp).Offset(1, 0) = k
Next k
End If
Next r
End Sub