|
- Option Explicit
- Sub test()
- Dim arrSrc, arrRst()
- Dim irow%, iCnt%, iNCnt%, iCol%, Ends%
- arrSrc = Range("A1").CurrentRegion.Value
- On Error Resume Next
- For irow = 1 To UBound(arrSrc) Step 4
- iNCnt = iNCnt + 1
- ReDim Preserve arrRst(1 To iNCnt)
- For iCol = 1 To 2
- If Err.Number = 0 Then
- Ends = irow + 3
- Else
- Ends = UBound(arrSrc)
- End If
- For iCnt = irow To Ends
- arrRst(iNCnt) = arrRst(iNCnt) & arrSrc(iCnt, iCol) & Chr(10)
- Next
- Next
- Next
- Range("c1").Resize(UBound(arrRst), 1) = Application.Transpose(arrRst)
- End Sub
复制代码
|
|