ªð¦^¦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

¦^´_ 2# samwang


±z¦n:¸É¤Wªþ¥ó.³Â·Ð±z

dsa.zip (52.52 KB)

TOP

¦^´_ 4# samwang


±z¦n:ÁÂÁ¦^ÂСC

­Y·s¼WBW2§@¬°ÃöÁä¦rªº±ø¥ó¡A³o¼Ë­n¦p¦ó§e²{µ²ªG©O? ¦A³Â·Ð¤F

dsa1.zip (75.09 KB)

TOP

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

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD