|
- Sub a()
- Dim i As Integer, j As Integer, k As Integer
- Columns("I:I").Copy
- Range("i1").PasteSpecial Paste:=xlPasteValues
- For i = [a65536].End(3).Row To 2 Step -1
- j = Cells(i, 1).End(xlToRight).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:h").Delete
- End Sub
复制代码 |
|