第一段
Sub EDSclear()
'
' EDSclear Macro
' 宏由 zhangguangbai 录制,时间: 2009-2-25
'
'
Range("B7:AS12").ClearContents
Range("B7:AS12,C3,C4:H4,N4:R4,N3,V4,Z4:AB4").ClearContents
Range("Z4:AB4").ClearContents
Range("B7:AS12,C3,C4:H4,N4:R4,N3,V4,Z4:AB4,AG4,AL4:AM4,AQ4:AS4,AO3").ClearContents
Range("AO3").ClearContents
Range( _
"B7:AS12,C3,C4:H4,N4:R4,N3,V4,Z4:AB4,AG4,AL4:AM4,AQ4:AS4,AO3,B15:I22,N16,N19,N20,N21,P22,V14:V21" _
).ClearContents
Range("V14").ClearContents
Range( _
"B7:AS12,C3,C4:H4,N4:R4,N3,V4,Z4:AB4,AG4,AL4:AM4,AQ4:AS4,AO3,B15:I22,N16,N19,N20,N21,P22,V14:V21,AE14:AE20,AO14:AO19,AR22" _
).ClearContents
Range("AR22").ClearContents
Range("c3").Select
End Sub
第二段
第三段Sub Macro1()
'
' Macro1 Macro
' 宏由 zhangguangbai 录制,时间: 2009-3-2Sub EDSinput()
Sheets("Database").Select
Range("A4:GF4").Copy
' Move the cellpointer to the first blank line at the bottom
ActiveCell.SpecialCells(xlLastCell).Activate
ActiveCell.Offset(1, -ActiveCell.Column + 1).Activate
Do While ActiveCell.Offset(-1, 0).Value = ""
ActiveCell.Offset(-1, 0).Activate
Loop
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Sheets("Input form").Select
Range("B7:AS12").ClearContents
Range("B7:AS12,C3,C4:H4,N4:R4,N3,V4,Z4:AB4").ClearContents
Range("Z4:AB4").ClearContents
Range("B7:AS12,C3,C4:H4,N4:R4,N3,V4,Z4:AB4,AG4,AL4:AM4,AQ4:AS4,AO3").ClearContents
Range("AO3").ClearContents
Range( _
"B7:AS12,C3,C4:H4,N4:R4,N3,V4,Z4:AB4,AG4,AL4:AM4,AQ4:AS4,AO3,B15:I22,N16,N19,N20,N21,P22,V14:V21" _
).ClearContents
Range("V14").ClearContents
Range( _
"B7:AS12,C3,C4:H4,N4:R4,N3,V4,Z4:AB4,AG4,AL4:AM4,AQ4:AS4,AO3,B15:I22,N16,N19,N20,N21,P22,V14:V21,AE14:AE20,AO14:AO19,AR22" _
).ClearContents
Range("AR22").ClearContents
Range("B32:AS33").ClearContents
Range("c3").Select
End Sub
'
'
Range("B32:AS33").Select
Selection.ClearContents
End Sub |