|
Baibdu 发表于 2015-1-12 15:34
谢谢老师了。试了一下,如果是纯两位数,运行正常。但遇上带0头的两位数,在代码里,就会出现问题,我搞不 ... - Sub tt()
- arr = [a1].CurrentRegion
- Dim brr(1 To 10000, 1 To 2)
- a = 47: b = 7
- For i = 1 To UBound(arr)
- For j = UBound(arr, 2) To 2 Step -1
- x = arr(i, j)
- If t = 0 And x = a Then
- y1 = arr(i, j - 2): y2 = arr(i, j - 1)
- brr(n + 2, 1) = "'" & Format(y1, "00") & Format(y2, "00") & Format(a, "00")
- t = t + 1
- ElseIf t = 1 And x = b Then
- y1 = arr(i, j - 2): y2 = arr(i, j - 1)
- brr(n + 1, 1) = "'" & Format(y1, "00") & Format(y2, "00") & Format(b, "00")
- brr(n + 1, 2) = arr(i, j + 1)
- t = 0
- n = n + 2
- Exit For
- End If
- Next
- Next
- With Sheet2
- .Cells.Clear
- .[a1].Resize(n + 2, 2) = brr
- .Activate
- End With
- End Sub
复制代码 |
|