Sub 正三角循环()
For i = 1 To 9For j = 1 To i
Cells(i, j) = i * j
Next j
Next i
End Sub
Sub 倒三角循环()
For j = 1 To 9For i = 1 To j
Cells(i, j) = i * j
Next i
Next j
End Sub
若要改变数值范围,改变“9”的数值即可
Sub 正三角循环()
For i = 1 To 9For j = 1 To i
Cells(i, j) = i * j
Next j
Next i
End Sub
Sub 倒三角循环()
For j = 1 To 9For i = 1 To j
Cells(i, j) = i * j
Next i
Next j
End Sub
若要改变数值范围,改变“9”的数值即可