- 帖子
- 31
- 主題
- 0
- 精華
- 0
- 積分
- 31
- 點名
- 0
- 作業系統
- win10
- 軟體版本
- office 2016
- 閱讀權限
- 10
- 性別
- 男
- 註冊時間
- 2016-10-4
- 最後登錄
- 2017-10-17
 
|
試試- Sub test()
- Dim Arr, Brr(1 To 65536, 1 To 2), C, UC
- Application.ScreenUpdating = False
- Arr = Range("a2:b" & Cells(Rows.Count, "a").End(3).Row).Value
- Range("e2", Cells(Rows.Count, "f")).ClearContents
- For Each A In Range("b2:b" & Cells(Rows.Count, "b").End(3).Row).Value
- For Each b In Split(A, Chr(10))
- If Len(b) > 0 Then
- n = n + 1
- UC = UC + 1
- Brr(n, 1) = b
- End If
- Next b
- m = m + 1
- Brr(m, 2) = UC
- UC = 0
- Next A
- [f2].Resize(n, 1) = Brr
- For j = 2 To UBound(Arr) + 1
- Cells(j, 1).Copy _
- Cells(Rows.Count, 5).End(xlUp).Offset(1, 0).Resize(Brr(j - 1, 2), 1)
- Next j
- Application.ScreenUpdating = True
- End Sub
複製代碼 |
|