- ©«¤l
- 315
- ¥DÃD
- 51
- ºëµØ
- 0
- ¿n¤À
- 367
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-29
- ³Ì«áµn¿ý
- 2021-10-12
|
¥»©«³Ì«á¥Ñ Airman ©ó 2015-11-24 10:01 ½s¿è
¦^´_ 31# GBKEE
GBKEE¶Wª©¤j:±z¦n!
¤£¦n·N«ä¡A±zÁÙ±Nµ{¦¡½X¥þ¥[µù¸Ñ~¨¯W±z¤F!·P®¦
«D±`±µªñ¤F!¥u³Ñ¤U¥æ¶°Èªº©w¸q¦³»~®t~
¥ý°²³]ARR=.Range("R" & b.Row),.Range("R" & b.Row)-T$3, .Range("R" & b.Row)-T$3*2¤TÓ´Á¼Æªº½d³ò¡A¥H§Q»¡©ú¡C
¥Ø«e¶Qµ{¦¡¬O¨Ì¾Úx_No = Array(m, n)¬O¹w³]¤§©T©wªº·j´MÈ~
§Y·ím¶ñ¤J07¡An¶ñ¤J39,«h±N¦bARR¦³Åã¥Ü07©Î39ªºÀx¦s®æ¦U¼Ð¥Ü©³¦â(¤£»Ýn3Ó´Á¼Æ¦P®É³£¦³)¡F
¤S¦p·ím¶ñ¤J01¡An¶ñ¤J49,«h±N¦bARR¦³Åã¥Ü01©Î49ªºÀx¦s®æ¦U¼Ð¥Ü©³¦â(¤£»Ýn3Ó´Á¼Æ¦P®É³£¦³)¡F....¨ä¾l¥H¦¹Ãþ±À¡C
¥»Åé»Ý¨Dªº¥æ¶°È¬O¯B°Êªº(§Y«D¹w³]ªº)~
§Y¬O¨Ì¾ÚARRªº3Ó´Á¼Æ¬O§_¦P®É³£¦³¬Û¦P¼Æ¦r¨Ó¨M©w¡J¦pªG3Ó´Á¼Æ³£¦³¬Û¦Pªº¼Æ¦r®É¡A«h¸Ó¬Û¦P¼Æ¦r§Y¬°¥æ¶°È~
EX1_§Y·íARRªº¥æ¶°È¬°01(§Y¥²¶·3Ó´Á¼Æ¦P®É³£¦³01)®É¡A«h3Ó´Á¼ÆÅã¥Ü01ªºÀx¦s®æ¦U¼Ð¥Ü©³¦â¡F
EX2_§Y·íARRªº¥æ¶°È¬°07,39(§Y¥²¶·3Ó´Á¼Æ¦P®É³£¦³07,39)®É¡A«h3Ó´Á¼ÆÅã¥Ü07,39ªºÀx¦s®æ¦U¼Ð¥Ü©³¦â¡F
EX3_·íARRªº¥æ¶°È¬°08,20,40(§Y¥²¶·3Ó´Á¼Æ¦P®É³£¦³08,20,40)®É¡A«h3Ó´Á¼ÆÅã¥Ü08,20,40ªºÀx¦s®æ¦U¼Ð¥Ü©³¦â¡F
EX4_·íARR³£¨S¦³¥æ¶°È(§Y3Ó´Á¼Æ¨S¦³¦P®É³£¦³¬Û¦Pªº¼Æ¦r)®É¡A«h3Ó´Á¼ÆªºÀx¦s®æ³£¬°µL©³¦â¡C..... ¨ä¾l¥H¦¹Ãþ±À¡C
¥H¤W ÂԨѰѦÒ!ÁÂÁ±z! |
|