- Sub lqxs()
- Dim b1, b2, i&, n&, aa$, bb$
- b1 = [a2:h2]
- b2 = [a4:h7]: n = 1
- For i = 1 To 8
- aa = aa & b1(1, i) & ","
- Next
- For i = 1 To UBound(b2)
- bb = ""
- For j = 1 To 8
- bb = bb & b2(i, j) & ","
- Next
- If aa <> bb Then
- n = n + 1
- Cells(n, 11).Resize(1, 8) = Application.Index(b2, i, 0)
- End If
- Next
- End Sub
- 表5表6一样。
复制代码 |