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

[µo°Ý] ·j´M³Ì«á¤@¦C³£¦³¬Û¦P¼Æ¦rªº²Õ¦X¡C

¦^´_ 40# ziv976688
"¨Ì¾Ú¶ñ¤Jªº´Á¼Æ°õ¦æ§Y¥i"
¨º´NµL©Ò¿×¤§ A*B ¤§²Õ¦X¥i¨¥¤F¡H
´«¥y¸Ü»¡
¦p¬° "¹ïµ¥¼Æ" ´N¤@©w­n¦³  A*B ²Õ¦X¤F¡H

TOP

¦^´_ 41# c_c_lai

ÁÙ¬O¦³A*B²Õ¦X
EX:RrngA = "100-200" ¡FRrngB = "10-12"
«h¦³
100*10¡F100*11¡F100*12
101*10¡F101*11¡F101*12
102*10¡F102*11¡F102*12
:
:
:
200*10¡F200*11¡F200*12
¦@303­ÓA*B²Õ¦X¡C

TOP

¦^´_ 42# ziv976688
¦¬¨ì¡Aµ{¦¡¼¶¼gÃø«×·U¨Ó·U°ª¤F¡C
¦pªGÁÙ¦³ºÃ°Ý¨ì®É«á­n¦A½Ð±Ð§A¤F¡C

TOP

¦^´_ 43# c_c_lai
³Â·Ð±z¤F!·q­Ô¨Î­µ¡C

TOP

¦^´_ 44# ziv976688
¦­¦w¡I

¥Ø«e¥u®t©|¥¼¼g¤J¨ì¤u§@ªí³æ¤º¡F
¥ý±N Beta ª©ªþ¤W¡A´£¨Ñ°Ñ¦Ò¡F
¦pªG«áÄòªí³æªº»s§@§A¯à±µ¤âªº¸Ü¡A
¨º§Ú´N¥i¥H¤U½Ò¥ð®§¤F¡I
BASE_T-1-Beta(MF).rar (30.11 KB)

P.S.  §Ú¯S·N±NDebug ¹Lµ{¤¤ªºµù¸Ñ (Remark)
        ¤º®e«O¯d¡A¬O­nÅý§A©úÁA¥¦ªººtºâ¹Lµ{¡C

TOP

¦^´_ 45# c_c_lai
±z¦n!
¤£¤~§¹¥þµLªk±µ¤â~~ÁÙ¬O¦³³Ò±z§J³º¥þ¥\¡CÁÂÁ±z^^

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2017-1-25 07:23 ½s¿è

¦^´_ 46# ziv976688
³Ìªñ¦]®a¨ÆÁc¦£¡A¬G¥u¯à©âªÅ­×¥¿¡F
ªþ¤W­×¥¿ (ÅÞ¿è) «á¤§°õ¦æµ²ªG¡A³Â·ÐÀˬd¬Ý¬Ý
¬O§_¥¿½T¡H
  1. -------------------------------------------
  2. DGroup(1) :  : Variant(1 to 4)
  3. DGroup(1,1) = "22" : Variant/String
  4. DGroup(1,2) = "20" : Variant/String
  5. DGroup(1,3) = "2" : Variant/String
  6. DGroup(1,4) = "1" : Variant/String
  7. -------------------------------------------
  8. NCnt :  : Variant/String(0 to 1)
  9. NCnt(0) = "2" : String
  10. NCnt(1) = "3" : String
  11. ----------------------------------
  12. ²Ä 1 ­Ó Ncount = 2 ²Õ¦X¦¸¼Æ
  13. ----------------------------------
  14. ²Ä 1 ­Ó A ²Õ¦X
  15. °_©l¦C = 12
  16. ²×¤î¦C = 27
  17. ´Á  ¶Z = 6
  18. ´Á  ¼Æ = 21
  19. ²Ä¤@²Õ = 01
  20. ²Ä¤G²Õ = 02
  21. ----------------------------------
  22. ²Ä 2 ­Ó A ²Õ¦X
  23. °_©l¦C = 8
  24. ²×¤î¦C = 23
  25. ´Á  ¶Z = 6
  26. ´Á  ¼Æ = 17
  27. ²Ä¤@²Õ = 01
  28. ²Ä¤G²Õ = 02
  29. ----------------------------------
  30. ²Ä 1 ­Ó B ²Õ¦X
  31. °_©l¦C = 11
  32. ²×¤î¦C = 26
  33. ´Á  ¶Z = 8
  34. ´Á  ¼Æ = 18
  35. ²Ä¤­²Õ = 30
  36. ----------------------------------
  37. ²Ä 2 ­Ó B ²Õ¦X
  38. °_©l¦C = 9
  39. ²×¤î¦C = 24
  40. ´Á  ¶Z = 8
  41. ´Á  ¼Æ = 16
  42. ²Ä¤­²Õ = 30
  43. ----------------------------------
  44. ²Ä 1 ­Ó C ²Õ¦X
  45. °_©l¦C = 12
  46. ²×¤î¦C = 27
  47. ´Á  ¶Z = 6
  48. ´Á  ¼Æ = 21
  49. ²Ä¤@²Õ = 01
  50. ²Ä¤G²Õ = 02
  51. ´Á  ¼Æ = 18
  52. ²Ä¤­²Õ = 30
  53. ----------------------------------
  54. ²Ä 2 ­Ó C ²Õ¦X
  55. °_©l¦C = 8
  56. ²×¤î¦C = 23
  57. ´Á  ¶Z = 6
  58. ´Á  ¼Æ = 17
  59. ²Ä¤@²Õ = 01
  60. ²Ä¤G²Õ = 02
  61. ´Á  ¼Æ = 16
  62. ²Ä¤­²Õ = 30
  63. ----------------------------------
  64. ²Ä 1 ­Ó Ncount = 3 ²Õ¦X¦¸¼Æ
  65. ----------------------------------
  66. ²Ä 1 ­Ó A ²Õ¦X
  67. °_©l¦C = 12
  68. ²×¤î¦C = 27
  69. ´Á  ¶Z = 6
  70. ´Á  ¼Æ = 21
  71. ²Ä¤@²Õ = 01
  72. ²Ä¤G²Õ = 02
  73. ----------------------------------
  74. ²Ä 2 ­Ó A ²Õ¦X
  75. °_©l¦C = 8
  76. ²×¤î¦C = 23
  77. ´Á  ¶Z = 6
  78. ´Á  ¼Æ = 17
  79. ²Ä¤@²Õ = 01
  80. ²Ä¤G²Õ = 02
  81. ----------------------------------
  82. ²Ä 3 ­Ó A ²Õ¦X
  83. °_©l¦C = 5
  84. ²×¤î¦C = 20
  85. ´Á  ¶Z = 6
  86. ´Á  ¼Æ = 14
  87. ²Ä¤@²Õ = 01
  88. ²Ä¤G²Õ = 02
  89. ----------------------------------
  90. ²Ä 1 ­Ó B ²Õ¦X
  91. °_©l¦C = 12
  92. ²×¤î¦C = 27
  93. ´Á  ¶Z = 8
  94. ´Á  ¼Æ = 19
  95. ²Ä¤T²Õ = 17
  96. ----------------------------------
  97. ²Ä 2 ­Ó B ²Õ¦X
  98. °_©l¦C = 9
  99. ²×¤î¦C = 24
  100. ´Á  ¶Z = 8
  101. ´Á  ¼Æ = 16
  102. ²Ä¤T²Õ = 17
  103. ----------------------------------
  104. ²Ä 3 ­Ó B ²Õ¦X
  105. °_©l¦C = 8
  106. ²×¤î¦C = 23
  107. ´Á  ¶Z = 8
  108. ´Á  ¼Æ = 15
  109. ²Ä¤T²Õ = 17
  110. ----------------------------------
  111. ²Ä 1 ­Ó C ²Õ¦X
  112. °_©l¦C = 12
  113. ²×¤î¦C = 27
  114. ´Á  ¶Z = 6
  115. ´Á  ¼Æ = 21
  116. ²Ä¤@²Õ = 01
  117. ²Ä¤G²Õ = 02
  118. ´Á  ¼Æ = 19
  119. ²Ä¤T²Õ = 17
  120. ----------------------------------
  121. ²Ä 2 ­Ó C ²Õ¦X
  122. °_©l¦C = 8
  123. ²×¤î¦C = 23
  124. ´Á  ¶Z = 6
  125. ´Á  ¼Æ = 17
  126. ²Ä¤@²Õ = 01
  127. ²Ä¤G²Õ = 02
  128. ´Á  ¼Æ = 16
  129. ²Ä¤T²Õ = 17
  130. ----------------------------------
  131. ²Ä 3 ­Ó C ²Õ¦X
  132. °_©l¦C = 5
  133. ²×¤î¦C = 20
  134. ´Á  ¶Z = 6
  135. ´Á  ¼Æ = 14
  136. ²Ä¤@²Õ = 01
  137. ²Ä¤G²Õ = 02
  138. ´Á  ¼Æ = 15
  139. ²Ä¤T²Õ = 17
  140. ----------------------------------
½Æ»s¥N½X

TOP

¦^´_ 47# c_c_lai
¦­¦w!
¤£¦n·N«ä¡A³o¼Ë¬Ý¤£¥Xµ²ªG¬O¹ïÁÙ¬O¤£¹ï^^"
¥i§_½Ð±zª½±µ°µ­Ó¥i°õ¦æ¨Ã²£¥Í®ÄªGÀɮתº¥DÀÉ~¥H§Q´ú¸Õ¡C
ÁÂÁ±z^^

TOP

¦^´_ 48# ziv976688
§Ö¹L¦~¤F¡AÁÙ¬O©â®É¶¡±N¥¦»°¥X¨Ó¡C
¤u§@ªí³æ©R¦W '  Sheets(Sheets.Count).Name = ""
§A¨Óµ¹§a¡I

BASE_T-1-B2(MF).rar (37.89 KB)

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-1-26 06:58 ½s¿è

¦^´_ 49# c_c_lai
¦­¦w!
·PÁ±z©ó¬K¸`«e¦Ê¦£¤¤~©|¼ö¤ß¬Û§U¡C
ÂǦ¹¥ý¦V±z«ô­Ó¦­¦~~~
·q¯¬:
°]·½¼s¶i!
Âó®a¥­¦w!


ÁÙ¬O­n¦³¹ê¨Ò¡A¸û®e©öÁA¸Ñ¬Û¤¬ªº»{ª¾¦³¦ó¤£¦P^^

±z§â¶}¼úª©(¤ñ¹ïªº°ò·Çª©)©M²Ä1­ÓÅçÃÒ²Õ¦X­«½Æ¤F¡C

¬Û¦Pªº«ü©w¸¹½X=11

============================================================================
StrRng = "1"
Nrange = "28" '
num = "15"
RrngA = "21-24"
CrngA = "1-2"
RrngB = "18-21"
CrngB = "1-2"
Order = ""   
Number = "3,11,21-26,43,49"
Ncount = "2-3"

¨ÏºÉ¦Y¥¤¤O¡A¼õ­Ó³q¾]~²×©ó¥H¤â¤u±N¤W­zªºÁ`¸ê®Æ§¨©M¨ä¤ºªº¤À¸ê®Æ§¨¤Î¨ä©Ò¦³®ÄªGÀÉ®×»s§@§¹¦¨¡C
ÂԨѰѦÒ!

P.S.Áö¦³­«½ÆÀ˵ø¦h¦¸¡A¦ý²¦³º¬O¤â¤u»s§@~­Õ¦³¿ù»~¡A©|½Ð±z¤£§[«ü¥¿¡CÁÂÁÂ!

BASE_T-1-B2a(MF).rar (180.34 KB)

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD