ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] keywordªº±ø¥ó­Y¹F2ºØ¥H¤W¡A¸Ó¦p¦ó«Ø¥ß»yªk?

[µo°Ý] keywordªº±ø¥ó­Y¹F2ºØ¥H¤W¡A¸Ó¦p¦ó«Ø¥ß»yªk?

½Ð°Ý¤U¦C»yªk¡Akeywordªº±ø¥ó­Y¹F2ºØ¥H¤W¡A¸Ó¦p¦ó«Ø¥ß»yªk?³Â·Ð½ç±Ð¡A·PÁ¡C
Sub BBB()
keyword = "AW1"      
For i = 7 To 26
    If Cells(i, 1) Like "*" & keyword & "*" Then   
        Cells(i, 3) = ""
        Cells(i, 4) = ""
        Cells(i, 5) = ""
        Cells(i, 6) = ""
End Sub

ÁÂÁ«e­±¦U¦ì«e½ú´£¨Ñ³o»ò¦hªº¤èªk¤Î«ü¾É

TOP

¦^´_ 13# ­ã´£³¡ªL


    ÁÂÁ«e½ú«ü¾É!

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2022-7-26 16:37 ½s¿è

¦^´_ 5# keny1021


¦pªG¹³½d¨Ò¤¤³o»ò¦³³W«ß, ±N¤å¦r¤À©î¤ñ¹ï§Y¥i~~~
¦p:«~¶µ(AW1)....§Q¥Î¬A¸¹©î¥XAW1
¦A¥ÎINSTR("/AW1/AW2/BW1/", "/AW1/") ¤ñ¹ï,
¬°¦ó­n¥Î "/"«e«á¥]ÂÐ?  ¨¾¤î  AW15 ¤Î AW1 ªº»~§P~~
¦p :INSTR("/AW15/AW8/BW9/", "AW1")  ³o­Ó´N·|¦³¿ù»~(³Q§ä¬d¤å¦r¤¤¨S¦³AW1, ¦Ó¬OAW15)

³o­Ó¥Î¦r¨å¤]¥i¥H~~

­Y¬O¦A½ÆÂø¨Ç, ¥i¯à­n¥Î"¥¿«h", ¦ý¨º¬O«D¤£±o¤w¦Ó¥Î¤§

TOP

¦^´_ 10# Andy2483


¤@­Óªí®æ, ³q±`·|¦³¤@­Ó[¥D¯Á¤Þ]Äæ,
¤º®e¤]³\¬O½s¸¹, ¤é´Á, ©Î§Ç¸¹, ¥¦¶·¦³¬Y¨Ç¯S©Ê...¤£­«ÂÐ, ©Î¤£¶¡Â_(§Y¤¤¶¡¤£¤¹³\ªÅ¥Õ¦æ),
¦]¦¹¥H³o¤@ÄæÀË´ú³Ì«á¤@¦æ«DªÅ¦ì¸m, ¥H©w¥X¾ã­Óªí®æªº¸ê®Æ½d³ò~~

²ßºD¤W, ³q±`¦bªí®æ¥ª¤è²Ä¤@Äæ, ­Y¦³¨ä¥¦±¡§Î, «h¨Ì¹ê»Ú­×§ï§Y¬O!!!

TOP

¦^´_ 11# samwang


    ÁÂÁ«e½ú«ü¾É!
±z¤Ó«È®ð¤F!

TOP

¦^´_ 10# Andy2483


  ¥HaÄ欰¥Dªº·N«ä¬O
aÄæ¬O¼ÐÃDÄæ,©Ò¥HaÄ檺³Ì«á¦C¼Æ³q±`·|µ¥©ó¾ã­Ó¤u§@ªí³Ì«á¦C¼Æ,
©Ò¥H¥Îªº¥k¤W¨ì¥ª¤Uªº¤è¦¡¦J¦C
¬O³o·N«ä¶Ü?
>> ¬Oªº¡A³o¥u¬O«á¾Ç¤@¨Ç²ßºD¤£¨£±o¬O­Ó¦nªº¤èªk¡AÁÂÁ  

TOP

¦^´_ 9# samwang


    ÁÂÁ«e½ú«ü¾É
Arr = Range([a7], Cells([a65536].End(xlUp).Row, "f"))
¥H«e³£¥Î³o¼Ëªº¤è¦¡¨Ó½T«O©w¸qªºÀx¦s®æ½d³ò,¤£·|¦]¬°[b7:f26]Àx¦s®æ¸ê®ÆÅܰʦӲ§°Ê

¥HaÄ欰¥Dªº·N«ä¬O
aÄæ¬O¼ÐÃDÄæ,©Ò¥HaÄ檺³Ì«á¦C¼Æ³q±`·|µ¥©ó¾ã­Ó¤u§@ªí³Ì«á¦C¼Æ,
©Ò¥H¥Îªº¥k¤W¨ì¥ª¤Uªº¤è¦¡¦J¦C
¬O³o·N«ä¶Ü?

TOP

¦^´_  samwang


    ½Ð±Ð«e½ú
1.Arr = Range([f7], [a65536].End(3))
2.Arr = Range([a7], [f65536] ...
Andy2483 µoªí©ó 2022-7-26 12:33


¦p±z»¡ªº³£¤@¼Ë¡A¥u¬O¦Ò¼{¬O¥HaÄ欰¥D¦Ó³o¼Ë¼g¦Ó¤w¡AÁÂÁÂ

TOP

¦^´_ 7# samwang


    ½Ð±Ð«e½ú
1.Arr = Range([f7], [a65536].End(3))
2.Arr = Range([a7], [f65536].End(3))

³o¨âºØ»yªk¦J¦CÀx¦s®æªº½d³ò³£¤@¼Ë,¤@¯ë³£¥Î²Ä2ºØ¤è¦¡
¬°¤°»ò«e½ú¥Î²Ä1ºØ¤è¦¡?
¦³¤°»ò¯S®í·N¸q¶Ü?

ÁÂÁ«e½ú!

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD