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

[µo°Ý] ¥ÎVBAø¹Ï°ÝÃD

[µo°Ý] ¥ÎVBAø¹Ï°ÝÃD

¦U¦ì¤j¤j¤È¦w
¤p§Ì§Ú¥Ø«e¸I¨ì¤@­Óª¬ªpÁ٧䤣¨ì¤èªk¸Ñ¨M
§Ú§Q¥ÎVBAµeXY¹Ï®É µo²{¦³´Xµ§¼Æ¾Ú¤£¬Oµe¦b¥¿½Tªº®y¼Ð¤W­±
´N¹³¤U¹Ïªºµµ¦â½u¬q¤¤ Y­ÈÀ³¸Ó¬O­n±q10~15 ¦ý³£Åܦ¨0¤F
§Úµo²{¦ü¥G¬O¦]¬°Àx¦s®æ¤WÅã¥Üºñ¦â¤p¤T¨¤§Î³y¦¨ªº  
½Ð°Ý³o­Ó°ÝÃD¯à¦bµ{¦¡½X¤º±Æ°£³o­Ó°ÝÃD¶Ü?
ÁÂÁÂ

¦^´_ 1# caponewilliam
²¾¨ì¦³ºñ¦âªºÀx¦s®æ¡A·|§i¶D§A¬°¤°»ò¼Ð¬°¿ù»~

¬Ý°_¨Ó¹³¬O®æ¦¡¿ù»~
¥kÁäÀˬdÀx¦s®æ®æ¦¡¡A­n¥Î¨Ó§@¹Ïªº '¼Æ­È' ¡A®æ¦¡¤£­n³]¬°¤å¦r¡C
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¦^´_ 1# caponewilliam
½Ð¤W¶ÇÀɮפè«K°»´ú¡C

TOP

¦^¨â¦ì¼ö¤ß¤j¤j
³o­Ó³¡¥÷§Ú¦³Àˬd¹L¤F ¤£¹Lµ²ªGÁÙ¬O¤@¼Ë
³o­Ó°ÝÃD¤£»Ý­n¦b¼gVBA®É´N·|µo¥Í¤F
¥u¬O¤£ª¾¹D­n«ç»ò¦b¼¶¼gµ{¦¡½X®ÉÁקK
Àɮצpªþ¥ó
ÁÂÁÂ
problem.rar (373.4 KB)

TOP

¥»©«³Ì«á¥Ñ Scott090 ©ó 2015-11-26 06:50 ½s¿è

¦^´_ 4# caponewilliam


    2#Á¿ªº¹ï¡A¤£­n¦s¦¨¤å¦r§Î¦¡
F13 §ï¦¨ = --B5
F14 §ï¦¨ = --E4
E13 ¤Î E14 Àx¦s®æ®æ¦¡§ï¬°¼Æ­È

©ÎªÌ ª½±µ§â B5 ¤Î E4 Àx¦s®æ®æ¦¡§ï¬° ¼Æ­È

TOP

¦^´_ 4# caponewilliam
¼Æ¦rªº®æ¦¡¤£­n³]¬°¤å¦r®æ¦¡

   
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2015-11-26 07:39 ½s¿è

¦^´_ 4# caponewilliam
¨Ì·Ó stillfish00¼Ó¥D¡BScott090¼Ó¥D
¥H¤Î GBKEE ª©¥Dªº»¡©ú¡A·í¥i¸Ñ¨M§A
¡u¦³°ÝÃDªº¼Æ¦C¡v¡C

¥ç§Y±N¡uE13¡v¡B¡uE14¡v¡B¡uB5¡v¡B
¡uE4¡vµ¥¥|­ÓÄæ¦ìªº¡yÀx¦s®æ®æ¦¡¡z
(«ö·Æ¹«¥kÁä)±N¡u¤å¦r¡v§ï¦¨¡u¼Æ­È¡v
µM«á§A¦A¨ì¡uE4¡vÄæ¦ì¤º­«·s¿é¤J100¡A
§AÆ[¹î¹Ïªí¬O§_¦³¤FÅܤơC



TOP

ÁÂÁ¦U¦ì¤j¤jÀ°¦£
³o¼Ë¤l°µªk ¦bexcel§ó¸Ó´N¥i¥H
¤£¹L·í³o¨ÇÀx¦s®æ¬O¥HVBA±N¼Æ¾Ú¿é¤J®É
´NÁÙ¬O¤@¼Ë·|¥X²{°ÝÃD
½Ð°Ý¬O­n¦bµ{¦¡¤º­×§ï¶Ü?
ÁÂÁÂ

TOP

´£¿ô¤@¤U¡G
±N¡e¤å¦r¡f®æ¦¡§ï¬°¡e¼Æ­È¡f®æ¦¡«á¡A¥²¶·­«·s¿é¤J¤@¦¸¼Æ­È¡A¤è¬°¦³®Ä­È¡I
¡e¯ù¸­³J¡f§ï¦¨¡e¥ÕµN³J¡f¡A¯ù¸­³J¤£·|¦Û¤v¥Õ¦^¨Ó¡A­n©ñ·s³J¡ã¡ã

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2015-11-26 10:28 ½s¿è

¦^´_ 8# caponewilliam
·í³o¨ÇÀx¦s®æ¬O¥HVBA±N¼Æ¾Ú¿é¤J®É

§A­n´£¨ÑVBA¼Æ¾Ú¿é¤Jªº¹Lµ{¤~¦³¿ìªkÀ°§A§ïµ½¡C¡C¡C
³q±`VBA¿é¤J¨ìÀx¦s®æ¤£·|¯S·NÂন¤å¦r¡C
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD