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

[µo°Ý] ½Ð±Ð¤£¦PÄæ­«½Æªº¸ê®Æµ¹¤©¬Û¦P©³¦â

[µo°Ý] ½Ð±Ð¤£¦PÄæ­«½Æªº¸ê®Æµ¹¤©¬Û¦P©³¦â

½Ð±Ð°ª¤â¡G¦pªþÀÉ¡A­ì¨Ó¸ê®Æ¦p¤u§@ªí1¡A·Q§e²{¦p¤u§@ªí2ªº±¡§Î¡A§YBÄæ»PEÄæ­Y¦³¬Û²ÅªÌ¥H¬Û¦PÃC¦â¼Ðµù¡AÃC¦â¥i¦Û¥Ñ¿ï©w¡A½Ð±Ð­n¦p¦ó°µ?ÁÂÁÂ
TEST.rar (7.35 KB)
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

Sub TEST()
Dim xR As Range, xF As Range
For Each xR In [B:B].SpecialCells(xlCellTypeConstants, 3)
¡@¡@Set xF = [E:E].Find(xR, Lookat:=xlWhole)
¡@¡@If Not xF Is Nothing Then xF.Interior.ColorIndex = xR.Interior.ColorIndex
Next
End Sub

¢ÐÄæ¶ñ¤°»ò¦â¡]¦Û¦æ¿ï©w¡^¡A¢ÓÄæ¸òµÛ¶ñ¦P¼ËÃC¦â¡ã¡ã

TOP

¦^´_ 2# ­ã´£³¡ªL
·PÁ ­ã´£³¡ªL¤jªº«ü¾É,
½Ð°Ý¦b°õ¦æ±zªºµ{¦¡®É,­Yµ¹¤©¤u§@ªí1ªºB3(R)©³¦â®É,¨ä¬Û¹ïªºE6(R)«o¤£·|¸òµÛB3(R)¦³¬Û¦Pªº©³¦â,¨ä¥LÀx¦s®æ«h¨S°ÝÃD,½Ð°Ý³o¬O¬Æ»ò­ì¦]?ÁÂÁÂ
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

¦^´_ 2# ­ã´£³¡ªL
¥t¥~½Ð±Ð ­ã´£³¡ªL¤j:
¦³®Éµ¹¤©BÄ檺©³¦â,¹ïÀ³¨ìEÄæÃC¦â·|¤£¦P,¦pªþÀÉ,½Ð°Ý¬O¬Æ»ò­ì¦].ÁÂÁÂ
TEST1.rar (7.66 KB)
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

¦^´_ 4# bhsm


§Ú³o´ú¸Õ¨S°ÝÃD, ¨â­Ó"R"¤£¬Û¦P, ¤@­Ó§t¦³ªÅ¥Õ¦r¤¸!
¶ñ©³¦âµ{¦¡½X, ¥i¥H¥Î±zªºª©¥»[¿ý»s]§Y¥i¨ú±o, ¸Õ¬Ý¬Ý~~

TOP

¦^´_ 5# ­ã´£³¡ªL
·PÁ ­ã´£³¡ªL¤jªº´£¥Ü,
1."R"ªº³¡¤À¯u¦p±z©Ò¨¥,¤w­×¥¿,ÁÂÁÂ
2.©³¦â¶]±¼ªº³¡¤À,§Ú¨Ì±zªº´£ÂI,¥ý¥H¿ý»sªº¤è¦¡Àò±oÃC¦â½X(¥¨¶°1),¦A°õ¦æ±zµ¹ªºµ{¦¡,©³¦â¨Ì·|¶]±¼,½Ð°Ý³o¬O·L³nªº°ÝÃD¶Ü?
3.ªþÀɦ³§Ú¿ý»sªº¥¨¶°,³Â·Ð ­ã´£³¡ªL¤jÀ°§Ú¬Ý¤@¤U,¬O§_­þ¸Ì¥X¿ù?³Â·Ð±z¤F,·P®¦
TEST2.rar (15.13 KB)
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

http://blog.xuite.net/hcm19522/twblog/354838322

TOP

¦^´_ 7# hcm19522
·PÁ hcm19522¤jªº¦^ÂÐ,¥i±¤¸ê½è¾|¶w¬Ý¤£À´
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

¦^´_ 6# bhsm


§Ú¥u¦³ OFFICE 2000, ´ú¤£¤F~~

TOP

¦^´_ 9# ­ã´£³¡ªL
·PÁ ­ã´£³¡ªL¤j,§Ú¦b¦Û¤vºN¯Á¬Ý¬Ý,·P®¦
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD