usana642

¦^´_ 33# GBKEE

¦A½Ð±ÐGBKEE¤j,§Ú¦A¼W¥[¤@­Ó''¬ö¿ý''¤u§@ªí,§â­pºâ«áªº¤p­p,¦Û°Ê¶×¤JÀx¦s,¦pªG¹j¤Ñ¦A«ö''­pºâ''¤u§@ªíªº''§ó·s''«ö¶s«á,§Æ±æ¯à¦b''¬ö¿ý''¤u§@ªí¦Û°ÊÀx¦s·í¤Ñ­pºâ«áªº¤p­pµ²ªG,Àµ½ÐGBKEE¤j¤j¦A¦¸¨ó§U,ÁÂÁ±z...
[attach]12878[/attach]

turbine

ÁÂÁÂGª©¥Dªº¸Ñ¨M¤è¦¡~~~
¦ý¨ä¹ê¤p§Ì§Ú¬O·Q­n¤@­Ó¶W°½Ãi¤è¦¡...
¦~¡B¤ë·|¦Û°Ê¶]
¦p¡G¦Û1990¦~01¤ë°_¦Û°Ê¤U¸ü¬ö¿ý¦bSHEET1«áÀx¦s¡A
¦A¦Û°Ê¸õ¨ì1990¦~02¤ë¡A¦Û°Ê¤U¸ü¬ö¿ý¦bSHEET1¤º¤U¤èªÅ¥Õ³B¡A±µÄò­è­è1¤ëªº¸ê®Æ§À
¦p¦¹­«ÂЦÜ2012¦~10¤ë³o¼Ë...
³o¼Ë¬O¤£¬O¤ÓÃi¤F...¤@..¤@"

reangame

¦^´_ 4# white5168


    ±ßÂI¦A¨Ó¤U¸ü¬Ý¬ÝÅo~~~~

c_c_lai

¦^´_ 38# GBKEE

¤U¸ü (96.68 KB)

2012-10-20 09:53

c_c_lai

¦^´_ 38# GBKEE
¹ïªº¡I

¤U¸ü (56.84 KB)

2012-10-20 09:04

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

GBKEE

¦^´_ 37# c_c_lai
·|¬O¦b [¤j¤p¤Î¤º®e] ¤¤¶Ü?
FormulaR1C1 ÄÝ©Ê   ¶Ç¦^©Î³]©wª«¥óªº¤½¦¡¡A¥Î¥¨¶°»y¨¥ªº R1C1 ¼Ë¦¡²Å¸¹ªí¥Ü¡CRange ª«¥ó¬°Åª/¼g Variant¡ASeries ª«¥ó¬°Åª/¼g String¡C
°õ¦æ«á ¦p¹Ï ¤Ä¿ï R1C1  «Kª¾

¤U¸ü (56.58 KB)

2012-10-20 08:48

1. Option Explicit
   
2. Sub Ex()
   
3.     Dim i
   
4.     For i = 1 To 5
   
5.         [c5].Cells(1, i) = "=r" & i & "c" & i
   
6.         [c5].Cells(2, i) = "=r[" & i & "]c[" & i & "]"
   
7.         [c5].Cells(3, i) = "=r[-" & i & "]c[-" & i & "]"
   
8.     Next
   
9. End Sub

½Æ»s¥N½X

c_c_lai

¦^´_ 36# GBKEE
¯u©_¡A¨S¬Ý¨ìËç¡H

¤U¸ü (28.25 KB)

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

GBKEE

¦^´_ 35# c_c_lai
«ö¥kÁä

   

¤U¸ü (23.64 KB)

2012-10-20 07:51

c_c_lai

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

usana642

¦^´_ 33# GBKEE


    ÁÂÁÂGBKEE¤j¤jªº§Ö³t¦^À³,¥i¥H¥¿½Tºâ¥X¤p­p¤F,¦A¦¸·PÁ±zªº¼ö¤ß¨ó§U,¯¬±z¶g¥½´r§Ö...