|
发表于 2016-3-11 17:15
|
显示全部楼层
本楼为最佳答案
Sub test()
Dim A, i, j
A = [G24:I30]
For i = 3 To UBound(A)
For j = 1 To UBound(A, 2)
If i = 3 Then
A(i, j) = A(1, j)
Else
A(i, j) = (A(i - 1, j) + 1) Mod 10
End If
Next j
Next i
[g24].Resize(i - 1, j - 1) = A
End Sub
以给定数据递增2.rar
(16.01 KB, 下载次数: 8)
|
|