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

¡u¤w¸Ñ¨M¡v§å¶q©w¸q¦WºÙªº¤èªk

¡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
  1. W=HCH_01       ¡övalue
  2. X==OFFSET('Call Setup Failure (%)'!$G$2,,,COUNTA('Call Setup Failure (%)'!$G:$G),1)    ¡ö{  }¸Ì­±ªº­È
  3. 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

¦^´_ 1# play9091


    ÀH·N¿ý»s¤@¤U¥¨¶°¨Ó·s¼W¦WºÙ§A´N¯à¤F¸Ñ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

§Ú¬O¥Î¿ý»s¤§«á¡A¤~¼g¥X¤W­±ªºVBAªº¡A¦ý¬O¡A§Ú·d¤£À´ªº¬O¡A¬°¤°»ò·|¥X¿ù¡K¡K

§Ú¥u¬O§â­ì¨Óªº
  1. ActiveWorkbook.Names.Add Name:="HCH_01", RefersToR1C1:="=OFFSET('Call Setup Failure (%)'!$G$2,,,COUNTA('Call Setup Failure (%)'!$G:$G),1)"
½Æ»s¥N½X
§ï¦¨
  1. W=HCH_01       ¡övalue
  2. X==OFFSET('Call Setup Failure (%)'!$G$2,,,COUNTA('Call Setup Failure (%)'!$G:$G),1)    ¡ö{  }¸Ì­±ªº­È
  3. ActiveWorkbook.Names.Add Name:=W, RefersToR1C1:=X       ¡ö³o¤@¦æ¥X¿ù¤F
½Æ»s¥N½X
´N¤£¦æ¤F¡H¡H
ªì¾ÇVBA¥E¨ìtwbts

TOP

¦^´_ 3# play9091


W="HCH_01"      
X="=OFFSET('Call Setup Failure (%)'!$G$2,,,COUNTA('Call Setup Failure (%)'!$G:$G),1)"   
ª`·NÂù¤Þ¸¹¡A³o³£¬O¦r¦ê«¬ºA¤~¹ï
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

«á¨Ó§Ú¥Î«ü©w¡uR¡AC¡vªº¤èªk¸Ñ¨M¤F¥¦¡K¡K
  1. =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

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD