|
发表于 2012-10-12 20:08
|
显示全部楼层
本楼为最佳答案
- Sub lqxs()
- Dim Arr, i&, j&, a(1 To 3), b(1 To 3), r%, Arr1(), x&
- Sheet1.Activate
- Columns("e:m").ClearContents
- Columns("e:m").NumberFormatLocal = "@"
- Arr = [c5].CurrentRegion
- For j = 1 To 9
- r = 0
- For i = 1 To UBound(Arr)
- For x = 1 To 3
- a(x) = Mid(Arr(i, 1), x, 1)
- Next
- r = r + 1
- ReDim Preserve Arr1(1 To r)
- a(1) = Val(a(1)) + j
- a(1) = Right(a(1), 1)
- Arr1(r) = Join(a, "")
- Next
- For i = 1 To UBound(Arr)
- For x = 1 To 3
- a(x) = Mid(Arr(i, 1), x, 1)
- Next
- r = r + 1
- ReDim Preserve Arr1(1 To r)
- a(2) = Val(a(2)) + j
- a(2) = Right(a(2), 1)
- Arr1(r) = Join(a, "")
- Next
- For i = 1 To UBound(Arr)
- For x = 1 To 3
- a(x) = Mid(Arr(i, 1), x, 1)
- Next
- r = r + 1
- ReDim Preserve Arr1(1 To r)
- a(3) = Val(a(3)) + j
- a(3) = Right(a(3), 1)
- Arr1(r) = Join(a, "")
- Next
- For i = 1 To UBound(Arr)
- For x = 1 To 3
- a(x) = Mid(Arr(i, 1), x, 1)
- Next
- r = r + 1
- ReDim Preserve Arr1(1 To r)
- a(1) = Val(a(1)) + j
- a(1) = Right(a(1), 1)
- a(2) = Val(a(2)) + j
- a(2) = Right(a(2), 1)
- Arr1(r) = Join(a, "")
- Next
- For i = 1 To UBound(Arr)
- For x = 1 To 3
- a(x) = Mid(Arr(i, 1), x, 1)
- Next
- r = r + 1
- ReDim Preserve Arr1(1 To r)
- a(1) = Val(a(1)) + j
- a(1) = Right(a(1), 1)
- a(3) = Val(a(3)) + j
- a(3) = Right(a(3), 1)
- Arr1(r) = Join(a, "")
- Next
- For i = 1 To UBound(Arr)
- For x = 1 To 3
- a(x) = Mid(Arr(i, 1), x, 1)
- Next
- r = r + 1
- ReDim Preserve Arr1(1 To r)
- a(2) = Val(a(2)) + j
- a(2) = Right(a(2), 1)
- a(3) = Val(a(3)) + j
- a(3) = Right(a(3), 1)
- Arr1(r) = Join(a, "")
- Next
- Cells(1, j + 4).Resize(r, 1) = Application.Transpose(Arr1)
- Next
- End Sub
复制代码 |
|