|
本帖最后由 采姑娘的小蘑菇 于 2015-7-26 16:34 编辑
先交了有时间再看看怎样修改,- Sub 按钮1_Click()
- Application.ScreenUpdating = False
- '关闭屏幕更新
- Dim i%, j%
- Worksheets("工资表").Activate
- '激活“工资表”
- Range("A2").AutoFilter Field:=1
- '将A2所在区域成为筛选状态
- j = Range("a1").CurrentRegion.Rows.Count
- '计算工资表的最大行号
- For i = j To 4 Step -1
- If Cells(i, 1) = "姓名" Then Range(Cells(i, 1), Cells(i, 9)).Delete shift:=2
- Next
- '从最后一行当A列的单元格等于“姓名”时删除当前行
- [a1].Select
- Application.ScreenUpdating = True
- '打开屏幕更新
- End Sub
复制代码- Sub 删除标题之for循环()
- Application.ScreenUpdating = False
- Dim i%, j%
- Worksheets("工资表").Activate
- Range("A2").AutoFilter Field:=1
- j = Range("a1").CurrentRegion.Rows.Count
- ' j = Range("a1").End(xlDown).Row
- ' j = Range("a" & Rows.Count).End(xlUp).Row
- For i = 3 To j
- If Cells(i, 1) = "姓名" Then Range(Cells(i, 1), Cells(i, 9)).Delete shift:=2
- Next
- [a1].Select
- Application.ScreenUpdating = True
- End Sub
复制代码- Sub 删除标题之forEach循环()
- Application.ScreenUpdating = False
- Dim i%, j%, rng
- Worksheets("工资表").Activate
- Range("A2").AutoFilter Field:=1
- i = Range("a1").CurrentRegion.Rows.Count
- For Each rng In Range("A3:A" & i)
- If rng = "姓名" Then Range(Cells(rng.Row, 1), Cells(rng.Row, 9)).Delete shift:=2
- Next
- [a1].Select
- Application.ScreenUpdating = True
- End Sub
复制代码- Sub 删除标题之DoWhileLoop循环()
- Application.ScreenUpdating = False
- Dim i%, j%
- Worksheets("工资表").Activate
- Range("A2").AutoFilter Field:=1
- j = Range("a1").CurrentRegion.Rows.Count
- i = 3
- Do While i < j
- If Cells(i, 1) = "姓名" Then Range(Cells(i, 1), Cells(i, 9)).Delete shift:=2
- i = i + 1
- Loop
- [a1].Select
- Application.ScreenUpdating = True
- End Sub
复制代码- Sub 删除标题之DoUntilLoop循环()
- Application.ScreenUpdating = False
- Dim i%, j%
- Worksheets("工资表").Activate
- Range("A2").AutoFilter Field:=1
- j = Range("a1").CurrentRegion.Rows.Count
- i = 3
- Do Until i > j
- If Cells(i, 1) = "姓名" Then Range(Cells(i, 1), Cells(i, 9)).Delete shift:=2
- i = i + 1
- Loop
- [a1].Select
- Application.ScreenUpdating = True
- End Sub
复制代码- Sub 删除标题之DoLoopWhile循环()
- Application.ScreenUpdating = False
- Dim i%, j%
- Worksheets("工资表").Activate
- Range("A2").AutoFilter Field:=1
- j = Range("a1").CurrentRegion.Rows.Count
- i = 3
- Do
- If Cells(i, 1) = "姓名" Then Range(Cells(i, 1), Cells(i, 9)).Delete shift:=2
- i = i + 1
- Loop While i < j
- [a1].Select
- Application.ScreenUpdating = True
- End Sub
复制代码- Sub 删除标题之DoLoopUntil循环()
- Application.ScreenUpdating = False
- Dim i%, j%
- Worksheets("工资表").Activate
- Range("A2").AutoFilter Field:=1
- j = Range("a1").CurrentRegion.Rows.Count
- i = 3
- Do
- If Cells(i, 1) = "姓名" Then Range(Cells(i, 1), Cells(i, 9)).Delete shift:=2
- i = i + 1
- Loop Until i > j
- [a1].Select
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|