|
- Sub xx()
- Dim arr
- Dim i&, n&
- With Sheet1
- n = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("A1:A" & n)
- .Range("a1:B" & n).ClearContents
- For i = 1 To n
- If i Mod 2 = 0 Then
- .Cells(i - 1, 2) = arr(i, 1)
- Else
- .Cells(i, 1) = arr(i, 1)
- End If
- Next
- End With
- End Sub
复制代码 |
|