|
VBA简化了许多工作,却因一些不必要的执行拖慢了速度,真让人好等。下面这段代码,我们就来找找茬,以资各位相互讨论学习之用。
八仙过海,一起来找茬,修理他,我们才顺气!
Sub Macro16() '13-15周岁花名册提取
Sheets("总花名册").Select
Rows("4:4").Select
Range("N4").Activate
Selection.AutoFilter
Selection.AutoFilter Field:=7, Criteria1:=">=13", Operator:=xlAnd, _
Criteria2:="<=15"
Range("A5:G65520").Select
Selection.Copy
Sheets("13-15周岁花名册").Select
Range("A8").Select
ActiveSheet.Paste
Sheets("总花名册").Select
Range("L5:X65520").Select
Range("X5").Activate
Application.CutCopyMode = False
Selection.Copy
Sheets("13-15周岁花名册").Select
Range("H8").Select
ActiveSheet.Paste
Sheets("总花名册").Select
ActiveWindow.ScrollColumn = 7
Range("AD5:AE65520").Select
Range("AE5").Activate
Application.CutCopyMode = False
Selection.Copy
Sheets("13-15周岁花名册").Select
Range("U8").Select
ActiveSheet.Paste
Sheets("总花名册").Select
Range("AK5:AK65520").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("13-15周岁花名册").Select
Range("W8").Select
ActiveSheet.Paste
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
Sheets("总花名册").Select
Range("AN5:AN65520").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("13-15周岁花名册").Select
Range("X8").Select
ActiveSheet.Paste
Sheets("总花名册").Select
Range("AW5:AW65520").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("13-15周岁花名册").Select
Range("Y8").Select
ActiveSheet.Paste
Range("C8").Select
Sheets("总花名册").Select
Application.CutCopyMode = False
Selection.AutoFilter
Range("AS10").Select
Range("B3:B4").Select
Sheets("13-15周岁花名册").Select
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Range("B6:B7").Select
End Sub |
|