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

[µo°Ý] VBA_R°Ï&T°Ï&$R$6°Ïµ¥¤T­Ó°Ï°ì¡i¨C¤@­Ó¡j¹ïÀ³¦C¤§µ´¹ï¥æ¶°­È¦U¼Ð¥Ü©³¦â¡C

[µo°Ý] VBA_R°Ï&T°Ï&$R$6°Ïµ¥¤T­Ó°Ï°ì¡i¨C¤@­Ó¡j¹ïÀ³¦C¤§µ´¹ï¥æ¶°­È¦U¼Ð¥Ü©³¦â¡C

VBA_¤T­Ó°Ï°ìªº¦PÄæ©Î¤£­­¦PÄ椧µ´¹ï¥æ¶°­È¦U¼Ð¥Ü©³¦â.rar (58.93 KB)

¡»¡»U7¥u¬O§@»²§U»¡©ú¤§¥Î¡A½ÐµL¶·²z·|¡C

»¡©ú¡J
R7-1¡AR7-2¡AR7-3¡AR7-4(R°Ï°ì)¡F
T5-1¡AT5-2¡AT5-3¡AT5-4(T°Ï°ì)¡F
R6-1¡AR6-2¡AR6-3¡AR6-4($R$6°Ï°ì)

»Ý¨D:
·íb<>""¡A ¥B$R$6°Ï¡äT°Ï=R°Ï*R°Ï¡ä$R$6°Ï=T°Ï*T°Ï¡äR°Ï=$R$6°Ï®É¡A
«h±NR°Ï&T°Ï&$R$6°Ïµ¥¤T­Ó°Ï°ì¡i¨C¤@­Ó¡j¹ïÀ³¦C¤§µ´¹ï¥æ¶°­ÈªºÀx¦s®æ¦U¼Ð¥Ü©³¦â¡C



½Ð°Ý¡J¦C9¥H¤Uªºµ{¦¡½X­n¦p¦ó¼W¼g?
Àµ½Ð¦U¦ì¥ý¶i¡B«e½ú¤£§[½ç±Ð!  ÁÂÁÂ!

¸Ô¦pªþ¥ó¡C
PS:»Ý¨D¨BÆJ±Àºt~½Ð¸Ô¨£¼ÐÅÒ¦³©³¦âªº¤u§@ªí¤§¹Ï¥Ü©M»¡©ú¡C

¦^´_ 1# Airman
¸É¥R¥t¤@µ{¦¡Å޿誺»¡©ú~§Æ±æ¹ï¸ÑÃD¦³À°§U~


ªþ¥ó: ¥t¤@µ{¦¡Å޿軡©ú.rar (3.55 KB)
ÂԨѰѦÒ!ÁÂÁÂ!

TOP

¦^´_ 2# Airman


Sorry~­×¥¿µ§»~~
²Ä7¦C: 2........¡A«h¨ä¾lªº4­Ó.....§ï¬°5­Ó
²Ä9¦C: 3........¡A«h¨ä¾l3­Ó.....§ï¬°4­Ó
  ÁÂÁÂ!

TOP

¦^´_ 1# Airman
¸U¤À©êºp~·U»¡·U¶Ã~#2©M#3§@¼o¡C

¦A­«·s¾ã²z~
·sªþ¥ó¡J ¥t¤@µ{¦¡Å޿軡©ú-­«·s¾ã²z.rar (3.79 KB)

ÂԨѰѦÒ!ÁÂÁÂ!

TOP

¥u·Q¨ì¡e¦Û­q¨ç¼Æ¡f¤Î¡e°Æµ{¦¡¡f¤è¦¡¡G
¤T°Ïµ´¹ï¥æ¶°¼Ð¥Ü©³¦âv01.rar (47.38 KB)

­Y¤£¾A¥Î¡A¤]·Q¤£¥X¨ä¥Lªk¤l¤F¡I¡I¡I

TOP

º|¡eÂI¡f¤F¡A½Ð¦Û¦æ¥[¤J¡e¬õ¦â¡fÂI¡G
If xNum <> "" Then Call ¤T°Ï¶ñ¦â(.[J6:P6], .[R6], .[T5], b(1, -1).Value, 4, xNum)

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2015-12-16 23:12 ½s¿è

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

­ã¤j:
¤£¦n·N«ä¡AÁ`¬O³Ò·Ð±z

¥Hµo°ÝÃDªþÀÉ´ú¸ÕOK¤F~·P®¦

PS:
¨þ~¨þ~±z¼g±o¤Óºë½o²Ó¿°¤F~¤p§Ì¤@®ÉÁÙ¤£ª¾À³¦p¦ó®M¶i¨ì¹ê»Úªº¨Ï¥Î¥DÀɤ¤?
¤µ©]¥J²Ó«ôŪ¶Qµ{¦¡¸Ñ½X»P¬ã²ß«á~©ú¤é¦A¦V±z´£³ø§i~ÁÂÁ±z

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2015-12-17 01:08 ½s¿è

¦^´_ 6# ­ã´£³¡ªL
­ã¤j:
¨þ~¨þ~°¨¤W¹J¨ì¤G­Ó°ÝÃD~¤£¬O¶Qµ{¦¡½X¦³°ÝÃD¡A¦Ó¬O¤p§Ìµ{«×¤ÓLowªº½t¬G~
Q1:½Ð°Ý¼Ò²Õªº¦WºÙ­n«ç»ò§ó§ï?
¤Wºô¬d~³£»¡¤£¯à§ó§ï~¥²¶·¥t¼gµ{¦¡~¦ý©ú©ú´N¬Ý¨ì±z¨S¦³¥t¼gµ{¦¡´N§ó§ï¤F

Q2:½Ð°ÝT7¤½¦¡ªº¦Û­q¨ç¼Æ¥i¥H§ó§ï¬°¤£¤Þ¥ÎUÄ檺­È¶Ü?
¦]¬°¦b¹ê»Úªº¨Ï¥ÎÀɤ¤µLªk¥HUÄæ§@»²§UÄæ(¥i¯à±z¨S¦³ª`·N¨ì¤p§Ì»¡©ú¤¤¤§"¤£¥Î²z·|UÄæ"ªºµù°O)

¥H¤W  ·q½Ð±z´f¤©½ç±Ð!·P®¦

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2015-12-17 04:32 ½s¿è

¦^´_ 5# ­ã´£³¡ªL
­ã¤j:
©I~²×©ó§ä¨ì¸ê®Æ~ª¾¹D«ç»ò§ó§ï¼Ò²Õ¦WºÙ¤F:lol

¥u³Ñ¤U¤½¦¡ªº°ÝÃD¤F~·|¤¤Â_¦bxNum = GetNumB1(.[J6:P6], .[R6], .[T5], b(1, -1).Value, 4)  
ÁÂÁ±z:D

ªí®æªø³o¼Ë(¤½¦¡·|¥k©Ô~Äæ¦ì¤£©w~©Ò¥HµLªk¥Î»²§UÄæ)

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2015-12-17 08:32 ½s¿è

¦^´_ 5# ­ã´£³¡ªL
­ã¤j:¦­¦w!
¤£¦n·N«ä¡A¬Ý¨Ó¬O¤p§Ìµe³D²K¨¬ªº»¡©ú·Sº×¤F~Åýµ{¦¡ÅÞ¿èÅܱo¦p¦¹½ÆÂø

¥H¥Ø«e¬Ý¨Ó~­n¸Ñ¨M°ÝÃDªºÄpµ²ÂI~GetNumB1~À³¸Ó¬O·|¤j¶O©P³¹~
¦]¦¹¥i§_~½Ð±z¥H¦pªþ¥ó¤¤ªº¦C19~¦C29ªºª½­z¦¡ªºµ{¦¡ÅÞ¿è¨Ó¼¶¼gµ{¦¡½X~
¥B¤½¦¡¤]¤£­n¥Î¦Û­q¨ç¼Æ¡A´N¥Î­ì¤½¦¡§Y¥i¡C
¦p¤é«á¦³»Ý­n§ïÅÜ­pºâ¦ì§}ªº®É­Ô~¤p§Ì¸ü¦Û¦æ§ó§ïµ{¦¡½X§Y¥i¡C

¥t¥~~¦b¶Q¸Ñµª§¹¦¨«á¡A°£¤FDATA!©MSheet1!¥H¥~ªº¨ä¥¦¤u§@ªí~¤p§Ì´N³£·|²¾°£~
©Ò¥H°£¤FDATA!©MSheet1!¥H¥~ªº¤u§@ªí³£¥u¬O§@»²§U»¡©ú¤§¥Î¡A½Ð±z¤£­n¤Þ¥Î©ó¤½¦¡©Îµ{¦¡½X¤¤¡C
ÁÂÁ±z

°Ñ¦Òªþ¥ó¡J VBA_¤T­Ó°Ï°ì¤£­­¦PÄæ©Î­­¦PÄ椧µ´¹ï¥æ¶°­È¦U¼Ð¥Ü©³¦â.rar (56.35 KB)

¥H¤W  Àµ½Ð±z´f¤©½ç±Ð~·P®¦

PS:¦pªþ¥ó¤¤ªº¦C19~¦C29ªºª½­z¦¡ªºµ{¦¡ÅÞ¿è~¤p§Ì¥i¥H¦Û¦æ®M¶i¨ì¹ê»Úªº¨Ï¥Î¥DÀɤ¤¡CÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD