|
发表于 2012-1-21 13:37
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim A, i%, j%, k%, x$, y$
- A = [b12:bj20]
- For j = 1 To UBound(A, 2) '遍历列
- For i = 7 To 9 '遍历18,19,20行
- Select Case Mid(A(1, j), i - 6, 1)
- Case 0 To 4
- x = 10
- Case 5 To 9
- x = 15
- End Select
- x = Right(CStr(x - Mid(A(2, j), i - 6, 1)), 1)
- A(i, j) = x
- For k = x + 1 To x + 4
- If k > 9 Then
- y = Right(CStr(k), 1)
- Else
- y = k
- End If
- A(i, j) = A(i, j) & y
- Next k
- x = "": y = ""
- Next i
- Next j
- Range("b18:bj20").NumberFormat = "@"
- [B12].Resize(9, UBound(A, 2)) = A
- End Sub
复制代码
Book2b.rar
(10.84 KB, 下载次数: 19)
|
|