ç¨å®æ¯è¾å¿«ãåæ¶æAltåF11è¿å
¥å®çé¢ï¼ç¹èåçæå
¥ï¼æ¨¡åï¼ç²è´´å¦ä¸ä»£ç ï¼
Sub test()
Dim i, j As Integer
Application.ScreenUpdating = False
For i = 1 To 5
For j = 1 To 4
Range("A" & 50 * (j - 1) + 200 * (i - 1) + 1 & ":B" & 50 * (j - 1) + 200 * (i - 1) + 50).Cut Cells(200 * (i - 1) + 1, j * 2 - 1)
Next j
Next i
For i = 5 To 1 Step -1
Rows(200 * (i - 1) + 51 & ":" & 200 * i).Delete
Next i
Application.ScreenUpdating = True
End Sub
å¨æ¤çé¢ç´æ¥æF5è¿è¡æ¤å®ï¼å®æã
温馨提示:答案为网友推荐,仅供参考