|
发表于 2012-2-16 17:07
|
显示全部楼层
本楼为最佳答案
- Sub Test_JUST()
- Dim Arr, i As Byte, j As Byte, ar(1 To 510, 1 To 1) As String, a(1 To 3) As Byte
- Dim m As Byte, n As Byte, k As Integer
- Arr = [d5:t7]
- For i = 1 To 3
- For j = 1 To 17
- For m = 1 To 3
- a(m) = CByte(Mid(Arr(i, j), m, 1))
- Next m
- For n = 0 To 9
- k = k + 1
- For m = 1 To 3
- ar(k, 1) = ar(k, 1) & (a(m) + n) Mod 10
- Next m
- Next n
- Next j, i
- Range("e12:e" & Rows.Count).Clear
- [e12].Resize(510) = ar
- End Sub
复制代码 试试效果 |
|