[µ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

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

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
--------

b9208

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