|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
骗30买个动车票
- Sub 整理()
- Dim vData As Variant, nRow As Long, nCol As Long
- Dim vFill As Variant, nFill As Long
-
- vData = Sheet1.[C2:F44].Value
- ReDim vFill(1 To 3, 1 To UBound(vData))
- nFill = 1
- For nRow = 1 To UBound(vData)
- If vData(nRow, 1) = vData(nFill, 2) Then
- For nCol = 1 To 3
- vFill(nCol, nRow) = vData(nFill, nCol + 1)
- Next
- nFill = nFill + 1
- ReDim Preserve vFill(1 To 3, 1 To UBound(vFill, 2) + 1)
- End If
- Next
- Do While nFill <= UBound(vData)
- For nCol = 1 To 3
- vFill(nCol, nRow) = vData(nFill, nCol + 1)
- Next
- nRow = nRow + 1
- nFill = nFill + 1
- Loop
- vFill = Application.WorksheetFunction.Transpose(vFill)
- Sheet2.[G2:I2].Resize(UBound(vFill)) = vFill
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|