|
原代码基础上做下改动,楼主测试一下:- Sub test()
- On Error Resume Next
- a = Array(1, 2, 4, 5, 6, 8)
- With Sheets("数据源")
- arr = .[a1].CurrentRegion
- ReDim brr(1 To 1000, 1 To UBound(arr, 2))
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If Len(arr(i, j)) = 0 Then
- arr(i, j) = arr(i - 1, j)
- End If
- Next
- If InStr(arr(i, 3), "、") Then
- s = Split(arr(i, 3), "、")
- For m = 0 To UBound(s)
- n = n + 1
- For x = 0 To UBound(a)
- brr(n, a(x)) = arr(i, a(x))
- Next
- brr(n, 3) = s(m)
- brr(n, 5) = Split(arr(i, 5), "、")(m)
- brr(n, 6) = Split(arr(i, 6), "、")(m)
- brr(n, 7) = Split(arr(i, 7), "、")(m)
- Next
- Else
- n = n + 1
- For j = 1 To UBound(arr, 2)
- brr(n, j) = arr(i, j)
- Next
- End If
- Next
- End With
- With Sheets("sheet1")
- .UsedRange.ClearContents
- .[a1].Resize(n, UBound(arr, 2)) = brr
- End With
- End Sub
复制代码
将多列有顿号的、有合并单元格的数据进行分行显示。。.rar
(11.04 KB, 下载次数: 14)
|
评分
-
查看全部评分
|