|
发表于 2011-7-8 11:28
|
显示全部楼层
本楼为最佳答案
回复 empty7401 的帖子
- Sub SCDY()
- Dim i As Long, B As Byte
- Sheet1.Copy After:=Sheet1
- B = 103
- For i = 103 To 4 Step -1
- If WorksheetFunction.CountBlank(Range("A" & i & ":P" & i)) = 16 Or Range("A" & i).Value = "总计" Then B = B - 1: Rows(i).Delete
- Next
- For i = 16 To 2 Step -1
- If WorksheetFunction.CountBlank(Range(Cells(4, i), Cells(B, i))) = B - 3 Or Cells(3, i).Value = "总计" Then Columns(i).Delete
- Next
- End Sub
复制代码
如果是删除横竖都没有数据的使用此代码- Sub SCDY()
- Dim i As Long, B As Byte
- Sheet1.Copy After:=Sheet1
- B = 103
- For i = 103 To 4 Step -1
- If WorksheetFunction.CountBlank(Range("B" & i & ":P" & i)) = 15 Or Range("A" & i).Value = "总计" Then B = B - 1: Rows(i).Delete
- Next
- For i = 16 To 2 Step -1
- If WorksheetFunction.CountBlank(Range(Cells(4, i), Cells(B, i))) = B - 3 Or Cells(3, i).Value = "总计" Then Columns(i).Delete
- Next
- End Sub
复制代码
如果删除竖没有数据,横没有表头的使用此代码
|
|