¡u¤w¸Ñ¨M¡v§å¶q©w¸q¦WºÙªº¤èªk
- ©«¤l
- 87
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 122
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2018-1-16
|
¡u¤w¸Ñ¨M¡v§å¶q©w¸q¦WºÙªº¤èªk
¥»©«³Ì«á¥Ñ play9091 ©ó 2012-3-7 19:47 ½s¿è
¥Ø«e§Ú¤â¤W¦³¤W¦Êµ§¸ê®Æ¶·n¥h©w¸q¦WºÙ¡K¡K§Úªº°µªk¦p¤U- W=HCH_01 ¡övalue
- X==OFFSET('Call Setup Failure (%)'!$G$2,,,COUNTA('Call Setup Failure (%)'!$G:$G),1) ¡ö{ }¸Ì±ªºÈ
- ActiveWorkbook.Names.Add Name:=W, RefersToR1C1:=X ¡ö³o¤@¦æ¥X¿ù¤F
½Æ»s¥N½X ¤£ª¾¹D¬°¤°»ò¦b«Øªº®ÉÔ·|¥X¿ù¤F¡A½Ð¤j®aÀ°Ó¦£¡K¡K |
|
ªì¾ÇVBA¥E¨ìtwbts
|
|
|
|
|
- ©«¤l
- 87
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 122
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2018-1-16
|
¦^´_ 2# Hsieh
§Ú¬O¥Î¿ý»s¤§«á¡A¤~¼g¥X¤W±ªºVBAªº¡A¦ý¬O¡A§Ú·d¤£À´ªº¬O¡A¬°¤°»ò·|¥X¿ù¡K¡K
§Ú¥u¬O§âì¨Óªº- ActiveWorkbook.Names.Add Name:="HCH_01", RefersToR1C1:="=OFFSET('Call Setup Failure (%)'!$G$2,,,COUNTA('Call Setup Failure (%)'!$G:$G),1)"
½Æ»s¥N½X §ï¦¨- W=HCH_01 ¡övalue
- X==OFFSET('Call Setup Failure (%)'!$G$2,,,COUNTA('Call Setup Failure (%)'!$G:$G),1) ¡ö{ }¸Ì±ªºÈ
- ActiveWorkbook.Names.Add Name:=W, RefersToR1C1:=X ¡ö³o¤@¦æ¥X¿ù¤F
½Æ»s¥N½X ´N¤£¦æ¤F¡H¡H |
|
ªì¾ÇVBA¥E¨ìtwbts
|
|
|
|
|
- ©«¤l
- 87
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 122
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2018-1-16
|
¦^´_ 4# Hsieh
«á¨Ó§Ú¥Î«ü©w¡uR¡AC¡vªº¤èªk¸Ñ¨M¤F¥¦¡K¡K- =OFFSET('CSSR (%)'!R2C2,,,COUNTA('CSSR (%)'!C2),1)
½Æ»s¥N½X ·PÁÂHsiehªºÀ°¦£¡K¡K
¥Ø«e©M§é½u¹Ï¾Ä°«·í¤¤¡K¡K¤£ª¾¹D¦p¦ó¥h«ü©w¸Ì±ªºX¶bY¶b¡H¡H¥i§_«ü±Ð¤@¤U¡H |
|
ªì¾ÇVBA¥E¨ìtwbts
|
|
|
|
|