|
发表于 2015-2-12 21:12
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim i&, lie&
- Application.ScreenUpdating = False
- For i = 5 To Range("a65536").End(xlUp).Row - 1 Step 2
- lie = Cells(i, Columns.Count).End(xlToLeft).Column + 1
- Cells(i + 1, 1).Resize(1, 30).Copy Cells(i, lie)
- Cells(i + 1, 1).Resize(1, 30) = ""
- Next
- [a:a].SpecialCells(xlCellTypeBlanks).EntireRow.Delete
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|