|
楼主 |
发表于 2019-1-25 10:26
|
显示全部楼层
Sub CheckM2() '不含物料编码
Dim d, lr, arr, i, S
Dim rng As Range
Sheet1.Columns(14).ClearContents
Sheet1.Cells.Interior.Pattern = xlNone
Sheet4.Rows("3:65536").Clear
Set rng = Sheet1.Range("A2:M2")
Set d = CreateObject("Scripting.Dictionary")
lr = Sheet1.[E65536].End(3).Row
arr = Sheet1.Range("C1:K" & lr)
j = 2
For i = 3 To UBound(arr)
S = arr(i, 1) & arr(i, 3) & arr(i, 4) & arr(i, 9)
d(S) = d(S) + 1
'---------------------------------------------------------------------
' If d(S) > 1 Then Sheet1.Rows(i).Copy Sheet4.Range("A" & j)
' j = j + 1 '该语句不能删除空行
'---------------------------------------------------------------------
If d(S) > 1 Then
Sheet1.Range(Sheet1.Cells(i, 1), Sheet1.Cells(i, 13)).Interior.Color = vbRed
Set rng = Union(rng, Sheet1.Range(Sheet1.Cells(i, "A"), Sheet1.Cells(i, "M")))
End If
Next
rng.Copy Sheet4.[a3]
Sheet4.Cells(2, 1).EntireRow.Delete
'Sheet4.Cells.Interior.Pattern = xlNone '取消填充颜色
End Sub
请问 这句Sheet4.Cells(2, 1).EntireRow.Delete 如何取消呢? |
|