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

¤U©Ô°ÝÃD

¦^´_ 10# lpk187

·PÁª©¤j,
¤p§Ì·Q­nªº¥¿¬O³o¼Ë, ¦ý¦³¤@¼Ë°ÝÃD, ²{®É¨C­Ó­Ü®w³£¬O12µ§¸ê®Æ, ¤p§Ì¸Õ¨ì³Ì§À¤@µ§¸ê®Æ, ³£¨S¦³°ÝÃD, ªí³æ¼u¥X, ¸Ó­Ü®w®w¦s¥çÅã¥Ü,
¦ý¤p§Ì¸Õ¹L¼W¥[­Ü®w¸ê®Æ, ¦]³fª««~ºØ·|¼W¥[, §Ú§â12µ§¸ê®Æ¼W¥[¦Ü20µ§©Î§ó¦h, ¦Ó¦bµ{¦¡¤¤¥ç¥[·s½s¸¹, ¦pA15, ·í§Ú±q¤U©Ô¤¤¿ï©wA15³fª«, ªí³æ¼u¥X, §Ú¿é¤J­Ü®w, ¦ý¨S¦³®w¦s, §Ú±q·s¼W²Ä¤@µ§¸ê®Æ°_A13¸Õ,
¥Ñ¸Ó·s¼W¸ê®Æ, «K¨S¦³®w¦sÅã¥Ü, ¨ì©³¬O¦ó­ì¦], ²{§â¦³·s¼W¸ê®ÆÀɤW¶Ç, ¸ÓÀɨC­Ó­Ü®w¤¤A13¶}©l«K¬O·s¼W¸ê®Æ, ½Ð¤j¤j±Ð¾É.
ÁÂÁÂÁÂ!
¸ê®Æ.rar (149.83 KB)

TOP

¦^´_ 11# ©P¤j°¶


TOP

¦^´_ 12# lpk187
ÁÂÁª©¤j, ¤w¸Õ¥Î,
°J¤ß·PÁÂ,

TOP

¦^´_ 13# ©P¤j°¶


   ¤£¹L¡A»P¨ä¤W­±¨ººØ¤èªk¨Ó¼W¥[¤£¦p¥Î¥t¤@ºØ¤è¦¡¨Ó¥Î
¦p§Ú¦b¤U­±µ{¦¡¤¤¥Î¤@­Ó¤½¥ÎÅܼÆ"X"¨Ó´À¥Nµ{¦¡¤¤ªº­×§ï
X = Sheets("´£¨ú³æ").Range("AJ1")
...
...
...
If InStr(X, Rng) > 0 Then
³o¼Ë´N¤£¥Î¦A¥h­×§ïµ{¦¡¤F
¸ê®Æ.rar (142.21 KB)

TOP

¦^´_ 13# ©P¤j°¶


   ¨ä Sheets("´£¨ú³æ").Range("AJ1")ªº¤º®e´N§Aªº»Ý¨D¨Ó­×§ï

TOP

¦^´_ 15# lpk187
ª©¤j, ¦w¦n,
X = Sheets("´£¨ú³æ").Range("AJ1")
If InStr(X, Rng) > 0 Then
¨ä Sheets("´£¨ú³æ").Range("AJ1")ªº¤º®e´N§Aªº»Ý¨D¨Ó­×§ï,
¦p¦ó§âµ{¤W­z¤§µ{¦¡¥[¤J²{¦³µ{¦¡¤¤, ¦]¤p§Ì¸Õ¦æ¥[¤J¥¢±Ñ,
¤Î½Ð±Ð¤j¤jX¬O§_¬O¦WºÙ,
ÁÂÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ lpk187 ©ó 2015-6-8 01:37 ½s¿è

¦^´_ 16# ©P¤j°¶


  §Ú¤w¸g¥[¨ì14¼Óªºµ{¦¡¤¤¤F¡A¹ï·Ó¤@¤U¡A§AÀ³¸Ó´Nª¾¹D¤F
"X" ¥u¬O¤@­ÓÅܼƦWºÙ¡A¦Ó¥¦¹ï·Óªº¥u¬OSheets("´£¨ú³æ").Range("AJ1")ªº¤º®e

TOP

¦^´_ 17# lpk187
·PÁ¤j¤j¡A¤w¸Õ¥Î¡AÁÂÁ¡I¡I

TOP

ª©¤j, ¦n
½Ð±Ð°ÝÃD, ¤U¦C¹Ï¤ù¤¤µ{¦¡¥X²{¶À¦â±¡ªp  , ¬O¦ó³B¿ù»~, ¤j¤j¥i§_¸Ñµª¸Ó¬qµ{¦¡½X,
ÁÂÁÂ!!
hong912

TOP

¦^´_ 19# hong912

§A­«·s°õ¦æWorkbook_Open¸Õ¸Õ

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD