|
楼主 |
发表于 2019-2-16 13:06
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
修改了夏代码,我这个是正在用的报表里的,但是未能解决与其他工作表核对核对的问题
'------------------------------------------------------------------------------------
Sub CheckM3() '最终完善版,只复制重复行,不包含物料编码
Application.ScreenUpdating = False
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)
For i = 3 To UBound(Arr)
j = Sheet4.[A65536].End(3).Row + 1
S = Arr(i, 3) & Arr(i, 4) & Arr(i, 9) 'Arr(i, 1) &
d(S) = d(S) + 1
If d(S) > 1 Then
Sheet1.Range(Sheet1.Cells(i, 1), Sheet1.Cells(i, 13)).Interior.Color = vbRed '颜色突出标记
Sheet1.Rows(i).Copy Sheet4.Range("A" & j)
Sheet4.UsedRange.Interior.Color = xlNone
End If
j = j + 1
Next
Sheet4.Activate
Application.ScreenUpdating = True
End Sub
'------------------------------------------------------------------------------------
|
|