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

[µo°Ý] ¦r¦ê¤¤¨S¦³¥]§t¬Y¦r¤¸¥Îªk

Like §PÂ_µ²ªG¬° True ©Î False,
¤Ï¦V, «h¥i§ï¬°
If .Cells(i, "A") Like "*AAA*" = False  Then .Rows(i).Delete
©Î
If Not .Cells(i, "A") Like "*AAA*"  Then .Rows(i).Delete

¥­±`²ßºD¥Î InStr , ¨ä¥Îªk»P¤u§@ªí¨ç¼Æ Find Ãþ¦ü, ¥u¬O¨ä°Ñ¼Æ¬Û¤Ï:
=Find(ÃöÁä¦r, ³Q¤ñ¹ï¦r¦ê)
SS = InStr(³Q¤ñ¹ï¦r¦ê, ÃöÁä¦r)

Like ¥t­Ó¦n³B, ¥i¥H§ó¦h¤è¦¡¼Ò½k¤ñ¹ï,
¨Ò¦p:
"AAA*"
"*AAA"
"AAA*B"

TOP

¦^´_ 4# v03586

OR ¥ô¤@
AND ¥þ³¡

¦h±ø¥ó­n½T»{¥Î­þ¤@­Ó?

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD