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

[µo°Ý] ¦¹¦¬´Mvba¼W¥[¸U¥Î¦r¤¸

¥»©«³Ì«á¥Ñ kimbal ©ó 2012-11-19 22:28 ½s¿è

¦^´_ 5# die78325


    §Aªº·N«ä¬O¦h©ó¤@­Ó±ø¥ó?
    ¦p  name="±i", name2="©ú"
    §ä¥X¨Óªº¥i¥H¬O "±i¤p©ú" , "±i¤j©ú", "©ú¤p±i" ©M "©ú¤j±i"
  1. If (Sheets("²Î¤@").Cells(i, 9) Like "*" & Name & "*") and (Sheets("²Î¤@").Cells(i, 9) Like "*" & Name2 & "*")  Then
  2.       ...
  3.   end if
½Æ»s¥N½X
¦pªG¦³¥ý«á¦¸§Çªº¸Ü,     (§Y§ä¥X¨Óªº¥i¥H¬O "±i¤p©ú" ©M "±i¤j©ú",¨S¦³ "©ú¤p±i" ©M "©ú¤j±i")
  1. If (Sheets("²Î¤@").Cells(i, 9) Like "*" & Name &"*" & Name2 & "*") Then
  2.       ...
  3. end if
½Æ»s¥N½X
©ÎªÌ¦A²³æ¤@ÂI¥u­n§âNAME³]©w¬° "±i*©ú", ´N¥i¥H±o¥X¤W­±²Ä2³¡¥÷ªº®ÄªG
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD