本帖最后由 hysys32 于 2015-10-21 21:21 编辑
richalken 发表于 2015-10-21 21:04
自己顶一下,希望有大侠路过出手相助
Sub test()
Dim arr, arrTmp
Dim rarr(1 To 100000, 1 To 5)
Dim i As Long
Dim k As Long
Dim j As Long
arr = Sheet1.Range("a1").CurrentRegion
For i = 1 To UBound(arr)
If VBA.InStr(1, arr(i, 5), "/") Then
arrTmp = Split(arr(i, 5), "/")
For j = 0 To UBound(arrTmp)
k = k + 1
For c = 1 To 4
rarr(k, c) = arr(i, c)
Next
rarr(k, 5) = arrTmp(j)
Next
Else
k = k + 1
For c = 1 To 5
rarr(k, c) = arr(i, c)
Next
End If
Next
Sheet2.Cells.Clear
Sheet2.Range("a1").Resize(k, 5) = rarr
End Sub
单行显示.rar
(16.74 KB, 下载次数: 8)