N行N列连续自然数用宏填充,如何编写?

来源:百度知道 编辑:UC知道 时间:2024/07/02 06:18:26
比如1-25填充5行5列、1-100填充10行10列,自然排序

Sub 宏1()
'
' 宏1 Macro
'
Dim S As String, N As Integer, i As Integer, j As Integer, k As Integer
S = InputBox("请输入填充数量:", "提示", "1-25")
N = InStr(S, "-")
If N = 0 Then
MsgBox "输入错误!", vbCritical, "出错"
Exit Sub
End If
N = Val(Mid(S, N + 1))
If Sqr(N) <> Fix(Sqr(N)) Then
MsgBox "请输入一个数的平方数!", vbCritical, "出错"
Exit Sub
End If
k = 0
N = Sqr(N)
For i = 1 To N
For j = 1 To N
k = k + 1
Cells(i, j) = k
Next
Next
End Sub