- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 3# c_c_lai
¤]¥i¥H³o¼Ë¼g- Option Explicit
- Sub Ex()
- Dim i, Rng As Range, Msg As Boolean, Sht As Variant
- With Worksheets("¤u§@ªí1")
- For i = .Range("A1").End(xlDown).Row To 1 Step -1
- Msg = False
- For Each Sht In Array(Worksheets("¤u§@ªí2"), Worksheets("¤u§@ªí3"))
- Set Rng = Sht.Range(Sht.Range("A1"), Sht.Range("A1").End(xlDown))
- If Not IsError(Application.Match(.Cells(i, "A"), Rng, 0)) Then Msg = True
- Next
- If Msg = False Then .Range("a" & i).Delete xlUp
- Next
- End With
- End Sub
½Æ»s¥N½X |
|