Sub 清零()
kk = MsgBox("清零将使部分单元格数据彻底消失,不可恢复!", 4, "提示")
If kk = 7 Then Exit Sub
Sheets("Sheet1").Select
Range("A1:D50").Select
Selection.ClearContents
Range("A2").Select
Sheets("sheet2").Select
Range("A3:D65536").Select
Selection.ClearContents
Range("A2").Select
End Sub
Sub 清零()
kk = MsgBox("清零将使部分单元格数据彻底消失,不可恢复!", 4, "提示")
If kk = 7 Then Exit Sub
Sheets("Sheet1").Select
Range("A1:D50").Select
Selection.ClearContents
Range("A2").Select
Sheets("sheet2").Select
Range("A3:D65536").Select
Selection.ClearContents
Range("A2").Select
End Sub