- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28
|
- Sub test()
- Set ld = CreateObject("Scripting.Dictionary")
- For Each sht In Array(Worksheets("¤u§@ªí2"), Worksheets("¤u§@ªí3"))
- For Each c In Range(sht.Range("A1"), sht.Range("A1").End(xlDown))
- If Not ld.exists(c.Value) Then
- ld.Add c.Value, c.Value
- End If
- Next
- Next
- With Worksheets("¤u§@ªí1")
- For i = .Range("A1").End(xlDown).Row To 1 Step -1
- If ld.exists(.Range("A1").Offset(i - 1, 0).Value) Then
- .Range("A1").Offset(i - 1, 0).Delete (xlShiftUp)
- End If
- Next
- End With
- Set ld = Nothing
- End Sub
½Æ»s¥N½X |
|