|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 lbay 于 2016-1-18 05:56 编辑
- Sub lqxs()
- Dim arr, i&, brr, zm, aa, j&, m&, n&
- Sheet2.Activate
- [a2:h500].ClearContents
- [a2:h500].Borders.LineStyle = xlNone
- zm = Array("A", "B", "C", "D", "E", "F")
- arr = Sheet1.[a3].CurrentRegion
- ReDim brr(1 To UBound(arr) - 1, 1 To 8)
- For i = 2 To UBound(arr)
- brr(i - 1, 1) = arr(i, 1)
- If InStr(arr(i, 2), ")") Then
- aa = Split(arr(i, 2), ")")
- brr(i - 1, 2) = aa(o) & ")": n = Len(aa(1))
- For j = UBound(zm) To 0 Step -1
- m = InStr(aa(1), zm(j))
- If m <> 0 Then
- brr(i - 1, j + 3) = zm(j) & "、" & Mid(aa(1), m + 2, n - m - 3): n = m
- End If
- Next
- End If
- Next
- [A2].Resize(UBound(brr), UBound(brr, 2)) = brr
- [A2].Resize(UBound(brr), UBound(brr, 2)).Borders.LineStyle = 1
- End Sub
- 蓝老师说的对,初学者就得多练习抄写代码,从中也能认真的学习很多东西。可能你是没时间,帮你抄写了。
复制代码 |
|