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

[¤À¨É] ¤j½L¨C¤ë¨C¤Ñ¾ú¥v¦¨¥æ¶q»Pª÷ÃB¤U¸ü

¦^´_ 3# GBKEE
ÆZ¤£¿ùªº¼gªk¡I
¤@¤ä Private Sub ¤j½L¦¨¥æ¸ê°T_Click() ´N§¹¦¨¤F©Ò¦³ªº§@·~¡C

TOP

¦^´_ 30# GBKEE
¹ï¤£°_¡A½Ð±Ð±z "§Ö¨ú¹Ï®×®æ¦¡" ¥\¯àÄæ §Ú­n¦p¦ó¤~¯à§ä¨ì¡H
§Ú¬O 2010 ª©¡C¦]³o®×¨Ò³B²z©Î³\§Ú·|¸I¤W¡C

TOP

¦^´_ 36# GBKEE
¯u©_¡A¨S¬Ý¨ìËç¡H
03.png
2012-10-20 08:09

¤S¡B¥H¤Uªº»yªk¹ê¦b¬O¦³¬Ý¨SÀ´¡A§Ú¤@ª½·Q¤F¸Ñ¥¦­Ì¥Nªíªº§t·N¡G
  1.             .Columns(7) = "=IF(rc[-3]=""Call"",1,0)"        ' R1C1ªí¥Üªk : ¤u§@ªí¤Wß}¤J¤½¦¡
  2.             .Columns(8) = "=IF(rc[-6]=r1c9,1,8)"
  3.             .Columns(9) = "=IF(rc[-2]=1,rc[-3],0)"
  4.             .Columns(10) = "=IF(rc[-3]=0,rc[-4],0)"
  5.             .Columns(11) = "=if(rc[-1]=0,rc[-6]*rc[-5],"""")"
  6.             .Columns(12) = "=if(rc[-2]<>0,rc[-7]*rc[-6],"""")"
½Æ»s¥N½X
§Ú±N =IF(rc[-3]=""Call"",1,0) ¶K¨ì¥ô¤@Äæ¦ì·QÆ[¹îµ²ªG¡A
µ²ªG¸ÓÄ檺­È«o¬O¾ã¬q =IF(rc[-3]=""Call"",1,0) ¤§¦r¦ê¡C

TOP

¦^´_ 38# GBKEE
¹ïªº¡I
01.png
2012-10-20 09:04

R1C1 §Ú·|¦n¦n¦a¥hÁA¸Ñ¡AÁÂÁ±z¡I

TOP

¦^´_ 38# GBKEE
01.png
2012-10-20 09:53

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD