|
发表于 2014-9-14 22:15
|
显示全部楼层
本楼为最佳答案
- Private Sub 清除_Click()
- Dim Rng As Range, i As Long, j As Long
- For i = 1 To 3
- For j = 1 To 11
- Set Rng = Sheets("1").Range(Cells(23 * i - 22, 12 * j - 11), Cells(23 * i, 12 * j))
- If Application.CountA(Application.Intersect(Rng, Rows(23 * i - 1))) Then
- Rng.ClearContents
- End If
- Next
- Next
- End Sub
复制代码
清除表格数字.rar
(59.7 KB, 下载次数: 1)
|
|