|
发表于 2014-12-20 11:18
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim rng As Range, j&, l&, n&
- Sheets(2).Activate
- l = ActiveSheet.UsedRange.Columns.Count - 9 '列
- For j = 1 To l Step 11
- Set rng = Cells(1, j).Resize(1, 10).EntireColumn
- n = rng.Find("*", searchdirection:=xlPrevious).Row
- If n < 36 Then rng.ClearContents
- Next
- End Sub
复制代码 |
|