备忘录1:
'删除重复记录
SubRemoveDuplicateRecord()
DimRow0AsLong,Row1AsLong
WithWorksheets("Sheet1")'工作表名称
Row0=.Cells(1048576,1).End(xlUp).Row
.UsedRange.RemoveDuplicatesColumns:=Array(1,2,3,4,5,6,7,8),Header:=xlYes
Row1=.Cells(1048576,1).End(xlUp).Row
EndWith
'MsgBox"共删除"&Row0-Row1&"("&