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

[µo°Ý] Ãö©óRange("A1").Formulaµ¥©óªÅ­È·|¥X²{FALSEªº°ÝÃD(¤w¸Ñ¨M)

[µo°Ý] Ãö©óRange("A1").Formulaµ¥©óªÅ­È·|¥X²{FALSEªº°ÝÃD(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ vpower ©ó 2011-5-25 08:39 ½s¿è

Range("A1").Formula="=IF(B1="","",NOW())"

°õ¦æ«áA1·|Åܦ¨=IF(B1=",",NOW())

³y¦¨§PÂ_¿ù»~,¥X²{FALSE.

ÁÂÁÂGBKEEª©¥D©Mluhpro¤j¤j,°ÝÃD¨Ì·Ó§A­Ì©Ò¨Ï¥Îªº¤è¦¡³£¥i¥H¸Ñ¨M§Úªº°ÝÃD,·PÁÂ.

TOP

¦^´_ 3# vpower

­è­èµo²{¨ä¹ê§A¥Î³o¼Ë¤U´N¤£·|¦³¿ù¤F :

Range("G2").Formula = "=IF(D2="""","""",D2+TIME(0,5,0))"

³o¬O¦]¬° FormulaR1C1 ¥k¤èªº¤½¦¡¤¤¥²¶·­n¥Î RxCx ªº§Î¦¡¨Óªí¥ÜÀx¦s®æªº¦ì§},
©Ò¥H D2 Åܦ¨­n¥Î R2C4 ¨Óªí¥Ü.(µM¥X¨Óªºµ²ªG·|Åܦ¨ $D$2)

¦Ó­Y·Q¥H¬Û¹ï¦ì§}¨Óªí¥Ü­n¥Î R[2]C[4],
ÁV¿|ªº¬O Excel ¤S·|¦Û°Ê¥H¥Ø«eªºÀx¦s®æ¦ì§}¥h­pºâ¤W­zªº¬Û¹ï¦ì¸m, (µ²ªG·|­pºâ¦¨ K4)
©Ò¥H¥H FormulaR1C1 ¨Ó«ü©w©T©w¥B¤£±a $ ªº¦ì§}·|¤ñ¥Î Formula ¨Óªº½ÆÂø.

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-5-24 20:23 ½s¿è

¦^´_ 3# vpower
À°§A¿ý»s¤F
  1. Sub Macro1()
  2. '
  3. ' Macro1 Macro
  4. ' ¦b 2011/5/24 ¿ý»sªº¥¨¶°
  5. '
  6. '
  7. Range("G2").Select
  8. ActiveCell.FormulaR1C1 = "=IF(RC[-3]="""","""",RC[-3]+TIME(0,5,0))"
  9. End Sub
½Æ»s¥N½X

FormulaR1C1,    Formula ¤£¤@¼Ë

TOP

¦^´_ 2# GBKEE
    §Ú¹ê»Ú¿ý»sªº¥¨¶°¦p¤U
   Range("G2").FormulaR1C1 = "=IF(D2="""","""",D2+TIME(0,5,0))"

    °õ¦æ«á,Àx¦s®æG2·|Åܦ¨=IF('D2'="","",'D2'+TIME(0,5,0))
    D2ªº«e«á·|¦h¥X¤@­Ó'
    Àx¦s®æª¬ºA·|Åã¥Ü#NAME?

TOP

¦^´_ 1# vpower
¥i¥¨¶°¿ý»s ¦bA1 ¿é¤J¤½¦¡  ¦A¬Ý¬Ýµ{¦¡½X
Range("A1").Formula = "=IF(B1="""" ,"""",NOW())"

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD