|
楼主 |
发表于 2017-1-22 20:29
|
显示全部楼层
非常感谢老师,问题已经解决。是excelhome的CC例例 老师不辞辛劳给我做的,看到老师的代码很简洁,只是想压缩一下文件大小和尽量使我可以多收藏一点知识,老师或许很忙,以后有问题还需要麻烦您的。谢谢您!【http://club.excelhome.net/thread-1325196-1-1.html】8、9楼!
excelhome的CC例例 老师的代码共享!
- Private Sub Worksheet_Activate()
- Dim rng As Range, arA, arB, arC, k, x%, y%, i%, j%
- [ac4].CurrentRegion.Offset(4) = ""
- arA = Sheets("科目汇总").[b4].CurrentRegion
- arC = Array(14, 15, 18, 19, 26, 27)
- ReDim arB(1 To UBound(arA), 1 To 14)
- For x = 5 To UBound(arA)
- If CStr(Left(arA(x, 1), 3)) = "504" Then
- j = j + 1
- k = Split(arA(x, 3), "-")
- y = UBound(k): i = 0
- If y = 0 Or y = 1 Then
- If rng Is Nothing Then
- Set rng = Cells(j + 5, "AD")
- Else
- Set rng = Union(rng, Cells(j + 5, "AD"))
- End If
- End If
- arB(j, 1) = arA(x, 1)
- arB(j, 2) = k(y)
- For y = 3 To 13 Step 2
- arB(j, y) = arA(x, arC(i))
- i = i + 1
- Next
- End If
- Next
- With [ac6].Resize(j, 14)
- .Font.Bold = False
- .Value = arB
- End With
- rng.Font.Bold = True
- End Sub
复制代码
|
|