请修改并简化下面程序,使之可以实现批量删除。具体在附件中,批量删除无限个相同表格,相同位置的数据。同时要把红底框中的数据也要删除。
Sub 删除数据()
'
' 删除数据 Macro
'
'
Range( _
"B5:E5,G5:H5,K5:M5,D6:H6,L6:M6,C7:E7,J7:M7,F8:H8,L8:M8,K9,F10:K10,M10,B13:M15") _
.Select
Range("B13").Activate
ActiveWindow.SmallScroll Down:=6
Range( _
"B5:E5,G5:H5,K5:M5,D6:H6,L6:M6,C7:E7,J7:M7,F8:H8,L8:M8,K9,F10:K10,M10,B13:M15,F16:G16,J16,M16" _
).Select
Range("M16").Activate
ActiveWindow.SmallScroll Down:=6
Range( _
"B5:E5,G5:H5,K5:M5,D6:H6,L6:M6,C7:E7,J7:M7,F8:H8,L8:M8,K9,F10:K10,M10,B13:M15,F16:G16,J16,M16,A18:G18,A19:G19" _
).Select
Range("A19").Activate
ActiveWindow.SmallScroll Down:=6
Selection.ClearContents
ActiveWindow.SmallScroll Down:=-30
End Sub
本帖最后由 zjdh 于 2016-4-6 18:32 编辑
Sub 删除数据()
Range("B5,G5,K5,D6,L6,C7,J7,F8,L8,K9,F9,F10,M9:M10,B13:M15,F16,J16,M16,A18:G19,A19") = ""
With Range("A20:A" & Range("A65536").End(3).Row)
Set c = .Find("姓 名")
If Not c Is Nothing Then
firstAddress = c.Address
Do
Range("A5:M19").Copy c
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With
End Sub
|