[µo°Ý] ¨Ì³]©w±ø¥ó§R°£¾ã¦C

b9208

½Ð±Ð«e½ú
¨ÌHÄ欰¡ªªÅ®æ¡ª©Î¡ª¦r¦êªº¦r¼Æ¤j©ó12¡ª¡A«h§R°£¸Ó¦C¡C¡]¦r¦ê¡@123456ABCDE12¡^
°Ñ·Ó¥»½×¾Â¤åÄm¡A­×­q¦ýµLªk§R°£¡A·q½Ð«e½ú«üÂI¡G
Sub yy()
Dim AA&, i&, myi As Range
With Sheets (¡§TEST¡¨)
AA = Range("A65536").End(xlUp).Row
¡@¡@For i = 6 To AA
¡@¡@¡@¡@If Len(Trim(Cells(i, 8).Value).Value) > 10 Or Cells(i, 8) = "" Then
¡@¡@¡@¡@If myi Is Nothing Then
¡@¡@¡@¡@Set myi = Cells(i, 8)
¡@¡@¡@¡@Else
¡@¡@¡@¡@Set myi = Union(myi, Cells(i, 8))
¡@¡@¡@¡@End If
¡@¡@¡@¡@End If
¡@¡@¡@¡@Next
¡@¡@If Not myi Is Nothing Then myi.EntireRow.Delete
End With
End Sub

GBKEE

¦^´_ 1# b9208
    5]http://forum.twbts.com/redirect.php?goto=findpost&pid=15511&ptid=2733]5#

b9208

ÁÂÁ«e½ú«üÂI
´N¬O¤Ö¤F¡ª¡D¡ª³oÂI
¤wOK¤F

b9208

½Ð±Ð¥ý¶i
¨ÌAÄæ¸ê®Æ§PÂ_¡A¦pAÀx¦s®æ¸ê®Æ = "¤¤³¡" ©Î " " ¡]ªÅ¥Õ¡^¡A«h§R°£¤­¦C¡C
¨Ò¦p¡GA6 = "¤¤³¡"¡A«h§R°£A6:A10¾ã¦C¡]§R°£¤­¦C¡^¡C
1# ¤§µ{¦¡½XÀ³¦p¦ó­×§ï
¸ê®Æ¬ù¦³¤W¸Uµ§¡C
ÁÂÁ«ü¾É¡I

b9208

½Ð±Ð¥ý¶i
¨ÌAÄæ¸ê®Æ§PÂ_¡A¦pAÀx¦s®æ¸ê®Æ = "¤¤³¡" ©Î " " ¡]ªÅ¥Õ¡^¡A«h§R°£¤­¦C¡C
¨Ò¦p¡GA6 = "¤¤³¡"¡A«h§R°£A6:A10¾ã¦C¡]§R°£¤­¦C¡^¡C
1# ¤§µ{¦¡½XÀ³¦p¦ó­×§ï
¸ê®Æ¬ù¦³¤W¸Uµ§¡C
ÁÂÁ«ü¾É¡I

hugh0620

¦^´_ 5# b9208


    http://forum.twbts.com/viewthrea ... ghlight=&page=3
    ³o¬O§Ú¥H«e°Ý¹L»P±zÃþ¦üªº°ÝÃD~ ´£¨Ñµ¹±z°Ñ¦Ò~
    À³¸Ó¥i¥H¸Ñ¨M§Aªº°ÝÃD~

b9208

¦^´_ 6# hugh0620

ÁÂÁ«e½ú«ü¾É
°ÝÃD¤w¸Ñ¨M¤F
¥t½Ð±Ð¥i¥H§ïµ½¤U­z¦h­«±ø¥ó" Or "¤§ªí¥Ü¤è¦¡¡H
---------
For Each A In Range("A6:A65536").SpecialCells(xlCellTypeConstants)
If A = "¤¤³¡" Or A = "­É¶U"  Or A.Offset(, 4) = "" Or A.Offset(, 11) = "ªL¤G" Or A.Offset(, 12) = "¥~¦í" Or A.Offset(, 12) = "¥~¦a" Then
--------

luhpro

§A¬Ý¬Ý©³¤U³o¼Ëªº¤è¦¡²Å¦X§Aªº»Ý¨D¶Ü?

¥ý³]©w¨â­Ó°}¦C(°²³]¬O ¦r¦ê°}¦C sC()¥]§t "¤¤³¡", "­É¶U", "",  "ªL¤G"... »P ¼Æ­È°}¦C iD() ¥]§t 0, 0, 4, 11, ...)
©Î¬O¨Ï¥Î Dictionary ¨C­Ó³æ¦ì³£¨â­Ó¸ê®Æ, ¨Ò¦p "¤¤³¡" »P 0, "­É¶U" »P 0, ...

with A
  bFind = False
  For iI = 1 To  7
    If A.Offset(, iD(iI)) = sC(iI) Then bFind = True
  Next iI

  If bFind = True Then
    ....
  End If
¦pªG Or ªº±ø¥ó¦³¤@¤j°ï®É, µ{¦¡·|¤ñ¸û®e©ö§PŪ¤S¤£®e©ö¥´¿ù¦r.

b9208

¦^´_ 8# luhpro
ÁÂÁ«e½ú«ü¾É
±Ä¥Î°}¦C¤è¦¡½T¹ê¼W¥[¾\Ū¡A¤]¥i¥H´î¤Ö¿ù»~
ÁÂÁÂ