|
发表于 2014-12-7 10:38
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim rng As Range, i&, j%
- Sheet1.Activate
- For j = 1 To 33 Step 16
- Set rng = Cells(1, j).Resize(9, 15)
- rng.Copy Sheet2.Cells(1, j)
- For i = 1 To 9
- If Application.CountA(Cells(i, j).Resize(1, 15)) = 15 Then Sheet2.Cells(i, j).Resize(1, 15) = ""
- Next
- Next
- End Sub
复制代码 |
|