|
- Sub a()
- Dim i As Integer, j As Integer, k As Integer
- For i = [a65536].End(3).Row To 2 Step -1
- j = Cells(i, 256).End(xlToLeft).Column / 2 - 2
- If j > 0 Then
- Rows(i + 1).Resize(j).Insert
- For k = 1 To j
- Cells(i, 4 + 2 * k - 1).Resize(1, 2).Copy Range("c1").End(xlDown).Offset(1, 0).Resize(1, 2)
- Next k
- End If
- Next i
- Range("e:z").Delete
- End Sub
复制代码 |
|