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

¦p¦ó§Q¥ÎVBA¤@Áä¦Û°Ê¶ñ¤J1©Î3©O?

¦^´_ 10# ­ã´£³¡ªL


    ¦n©Ç¡A§â±zªºVBA¶K¦bSheet2¤u§@ªí«á¡A¦bCÄæ¸Ì¤@ª½­×§ï¤º®e¡A¤]¨S¨£¥L¦Û°Ê¶ñ¤J©O?
¬O§Ú¶K¿ù¦ì¸mÁÙ¬O»Ý­n¬Æ»ò¨ä¥L°Ê§@¶Ü?

¹ï¤F¡I§Ú·|IJµoªº "¦Û°Ê¶ñ¤J" ªº­×§ïCÄ檺½d³ò¦³¼W¥[¨ìC3:C200³á¡A¦]¬°¦³®É¨Ï¥ÎªÌ·|²§°Ê¨ì100¦h¦C¡A©Ò¥H§Ú°®¯Ü§â½d³ò¼W¥[¨ìC200¤]·|IJµo¡C

TOP

¦^´_ 11# RCRG


¤½¦¡¤Îµ{¦¡¤£¬O»IÃĶK¤F´N¥Î, ¥ý¥h¤F¸Ñ¤@¤U, ¦³°ÝÃD¸ÕµÛ¥h­×§ï¦A´ú¸Õ¬Ý¬Ý~~

TOP

¦^´_ 10# ­ã´£³¡ªL


    ÁÂÁ­ã¤jªº«ü¥¿¡A´ú¸Õªºªºµ²ªG¡A§Ú¦n¹³§ä¤£¨ì­×§ïCÄæ¦ì«á´N¦Û°Ê¶ñ¤Jªº¡A¦³¤@¨Ç³£¬O§Ú¥u¬O·Æ¹«ÂI¿ïCÄæ¦ì¡AÁÙ¨S­×§ï´N¶ñ¤J¤F¡A¤£ª¾ÁÙ¦³¨ä¥L¥i¥H¿ï¶Ü

TOP

¦^´_ 13# RCRG


Private Sub Worksheet_Change(ByVal Target As Range)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

¬Ý¤@¤U¨âªÌ¤£¦P³B, ¥i°Ñ¦ÒVBE»¡©ú~~¨Æ¥ó~~

TOP

¦^´_ 14# ­ã´£³¡ªL


    ÁÂÁ­ã¤j¸Ñµª¡A°Ñ·Ó±zªºµª®×¡A§Ú¦Û¤v¦AÅܧó¤@¤U¤âªk¡A¤]ºâ¬O¥i¥H¦Û°ÊIJµo¤F¡A¦A¤@¦¸·PÁ±z¦h¦¸ªºÀ°¦£¡I

TOP

¦p¦ó§Q¥ÎVBA¤@Áä¦Û°Ê¶ñ¤J1©Î3©O? Part2

http://forum.twbts.com/viewthrea ... a=pageD1&page=1
¤W¦Cºô§}¬O­ì°ÝÃD»P¸Ñµª¡F

¦ý¬O³Ìªñ¤S¦³·sªº»Ý¨D¡A´N¬O¦pªG¦Û°Ê¦bBÄæ¦ì¶ñ¤J1©Î3«á¡A¦³¨Ç¨Ï¥ÎªÌ·|»~§ï¨ìBÄæ¦ì¦Û°Ê¶ñ¤Jªº¼Æ­È¡A
¤£ª¾¯à§_ ¼u¥Xµøµ¡  "¶ñ¤J¸¹½X»P¹w³]¤£¦P¡A½Ð½T»{¬O§_­n­×§ï¡I"  ¨Ó´£¿ô¤@¤U¨Ï¥ÎªÌ¡C


¥H¤W°ÝÃD¡A¦³³Ò¤j¤jÀ°¸Ñ¡I

TOP

¤W¦Cºô§}¬O­ì°ÝÃD»P¸Ñµª¡F

¦ý¬O³Ìªñ¤S¦³·sªº»Ý¨D¡A´N¬O¦pªG¦Û°Ê¦bBÄæ¦ì¶ñ¤J1©Î3«á¡A¦³¨Ç¨Ï¥ÎªÌ·|»~§ï¨ì ...
RCRG µoªí©ó 2015-11-24 16:39



    ­ì¨Ó³o¼Ëºâ­«½Æµo©«¡AÁÂÁª©¤j´£¿ô»PÀ°¦£¦X¨Ö¡A¤]§Æ±æ¦U¦ì¤j¤j¯àÀ°¸Ñ¤W1¼Ó(16¼Ó)PATR2°ÝÃD¡A3Q¡I

TOP

¦^´_ 3# ­ã´£³¡ªL
½Ð°Ý­ã¤j,¡@.Formula = "=IF(C3="""","""",3^(1-COUNT(MATCH(C3,AA$2:AA$500,))))"¤¤
COUNT(MATCH(C3,AA$2:AA$500,))))ªº­È­n¹À¬O0,­n¹À¬O1,µ²ªG¤~¯àÅã¥Ü¥X1©Î3,¦ÓMATCH¬O§ä¥X¬Û²Å©Ò¦bªº¦ì¸m,¨Ò¦p¥i¯à§ä¨ì¦b²Ä400¦C,³o¼Ë«ç»ò·|±o¥X0©Î1ªºµ²ªG?

TOP

¦^´_ 18# ¤d·u´M
§ä¨ìµª®×¤F,­ì¨Ó¬OCOUNTªº§@¥Î:§ä¨ì¥]§t¼Æ¦rªºÀx¦s®æ­Ó¼Æ,©Ò¥HMATCHªºµ²ªG¤£ºÞ¬O¦ó¼Æ¦r(©Î§ä¤£¨ì),µ²§½¤£¬O0´N¬O1!

TOP

¦^´_ 10# ­ã´£³¡ªL
§Q¥Î3^0, 3^1¨Ó¶ñ¤J1©Î3, ¯u§®, «ôªA, ¦¬¤U, ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD