|
见以下代码所示:- Sub EP()
- Dim i As Integer, m As Integer, Rnum As Integer
- Dim ar1, ar2, re
- ar1 = Sheets(2).Range("A1").CurrentRegion
- ar2 = Sheets(2).Range("F1").CurrentRegion
- ReDim re(1 To UBound(ar1), 1 To 4)
- For i = 1 To UBound(ar1)
- m = 0
- For j = 1 To UBound(ar2)
- If ar1(i, 1) = ar2(j, 1) And ar1(i, 2) = ar2(j, 2) And ar1(i, 3) = ar2(j, 3) And ar1(i, 4) = ar2(j, 4) Then
- m = m + 1
- Rnum = Rnum + 1
- re(Rnum, 1) = ar1(i, 1)
- re(Rnum, 2) = ar1(i, 2)
- re(Rnum, 3) = ar1(i, 3)
- re(Rnum, 4) = ar1(i, 4)
- Exit For
- End If
- Next j
- Next i
- Sheets(2).[p1].Resize(UBound(re), 4) = re
- End Sub
复制代码
查询相同一组附件.rar
(107.48 KB, 下载次数: 2)
|
评分
-
查看全部评分
|