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

Åܰʬö¿ýªºµ{¦¡

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2016-3-22 12:21 ½s¿è

¦^´_ 22# jackyq

1.sheet4¬O§Ú¦Û¤v§ïªº¡A¶Ã®Mªº¡A«¢«¢
2.§Ú¥²¶·½L¤¤§ì¨ú¾ú¥v¸ê®Æ¡A©Ò¥H­n¥Î¦^¸É¸ê®Æªº¤è¦¡
3.§Ú¤£¬O­n§ì¨ú«Ü¦h¾ú¥v¸ê®Æ¡A¦Ó¬O½L¤¤­n§ì¨ú·í¤Ñ¸ê®Æ°µ¹Bºâ¡A§Ú­nªº¸ê®Æ¦³¥x«ü©M¥[ÅvªºtickÀÉ

­ì¥»¬O¥x«ü¸ò¥[Åv³£¥ÎAPI§ì¦ý¬O¦]¬°¸s¯qªº¸ê®Æ¦³»~¡A©Ò¥H§ï¥ÎÅܰʬö¿ýªº¡A¦pªG¸ê®Æ¦³»~¹ï¤U³æ·|¦³¼vÅT

¤£ª¾¹D³o¼ËJ¤j¦³¤F¸Ñ¶Ü??

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2016-3-22 12:51 ½s¿è

¦^´_ 24# jackyq


    §Ú»Ý­n·í¤Ñªº©Ò¦³tick°µ¤U³æªº§PÂ_¡A¤@©w­n§ì¨ì©Ò¦³tick¡A©Ò¥Hj¤j¡A§ÚªºÀɮ׬OµLªk¾ã¦X¶Ü¡H

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2016-3-22 13:32 ½s¿è

¦^´_ 26# jackyq

j¤j¡A³o¼Ë»¡¦n¤F¡AÅý§Ú­è­è¤W¶Çªº¨º­ÓÀɮתº»ù®æ°O¿ý³¡¥÷¥i¥Hwork¡A³o¼Ë¦³¿ìªk¶Ü¡H
¨ä¥L³¡¥÷¤£ºÞ¡A´NÅýsheet4¨º­Ó»ù®æ°O¿ý¥i¥H°õ¦æ´N¦n¡Aj¤jÅý§A¶O¤ß¤F¡A·PÁÂ

¥t¥~½Ð±Ð¤@¤Uj¤j¬O­þ¸Ì¤H°Ú¡H

TOP

¦^´_ 26# jackyq


    j¤j¡A¬O¤£¦n¾ã©M¶Ü¡HÁÙ¬O§Ú¤§«e¶Ã«÷´êªºµ{¦¡½X¤Ó¶Ã¤F¡H

TOP

¦^´_ 29# jackyq


    j¤j¡A§Ú¬Oapiªº³¡¥÷§ì´Á³f¡A¥t¥~ªº»ù®æ¬ö¿ý§ì¥[Åv¡A³o¼Ë¦³¤ñ¸û²M·¡¶Ü¡H
µM«á¨â­Ó³£¥Î©w®É§ó·s¡A©êºpªí¹F¤£¬O«Ü²M·¡¡A»ù®æ°O¿ý³¡¥÷´N³]©wÅÜ°Ê°O¿ý
¨ì®É­Ô¥u¦³TX00¨S¦³tsae

TOP

¦^´_ 31# jackyq


    J¤jÁÂÁ§A¡AÅý§A¶O¤ß¤F

TOP

¥»©«³Ì«á¥Ñ ÂŤÑÄR¦À ©ó 2016-4-7 22:55 ½s¿è

¦^´_ 31# jackyq

ªÑ²¼.rar (18.4 KB)

J¤j¤£¦n·N«ä¦A½Ð±Ð§A¤@¤U¡A§Ú¤§«eªºµ{¦¡½X¬O³]©w¬°¬Y¤@­Ó­ÈÅÜ°Ê´N¬ö¿ý¡A¨º·Q½Ð±Ð¤@¤UJ¤j¦pªG§ÚªºÅÜ°Ê­ÈÅܦh­Óªº¤Æµ{¦¡½X­n¦p¦ó§ó§ï??

¨Ò:¦p¹Ï©Ò¥Ü¡A¦pªGC2ÅÜ°Ê´N©¹¤U¬ö¿ýB2-C2¡A¦ý¬O¨ä¥L¤£¬ö¿ý¡A¤U­Ó®É¶¡C2¨SÅÜ°Ê´«E2ÅÜ°Ê¡A«h°O¿ýD2-E2¡A¤@¼Ë¨ä¥L¤£¬ö¿ý¡A¥H¦¹Ãþ±À¡A§ÚªºÅܰʭȭ쥻¥u¦³³]©wIf (WR = 3) Or _  (Range("C" & WR - 1) <> Range("C2")) Then 'Á`¶q¦³²§°Ê®É¤~°O¿ý¡A§Ú²{¦b­n³]©w¦h­Ó¡A©Ò¦³¶qªº³¡¤À³£³]©w¬°ÅÜ°Ê´N¬ö¿ý¡A­n¦p¦ó§ó§ïµ{¦¡½X©O??

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD