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

[µo°Ý] [BV321].Formula = [BV2] & [BW1] ¡A[BV321]¥i¥H¬OÅܼÆ??

[µo°Ý] [BV321].Formula = [BV2] & [BW1] ¡A[BV321]¥i¥H¬OÅܼÆ??

½Ð°Ý VB ³¡¥÷
¤§«e ³£¬O³o¼Ë³B²z

    Range("CJ" & [CJ17] + 1).Select                          '±N ¦³»Ý­nÅÜ¼Æ Àx¦s®æ
    ActiveCell.FormulaR1C1 = "=R[-318]C"            '¾É¤J Àx¦s®æªº¤º®e  ¬O¤½¦¡

    [BV321].Formula = [BV2] & [BW1]                     '·Q Ãþ¦ü ³o¼Ë....

     [BV321]¦ý §Æ±æ ¥i¥H¬OÅܼƠ 

    ' ¦p¤U³o¼Ë ¦ý ¬O¿ù»~
     Range("BV" & [BV17] + 1).Select.Formula = [BV2] & [BW1]

¯à³Â·Ð ¸Ñµª¤@¤U ·P®¦
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¥»©«³Ì«á¥Ñ lpk187 ©ó 2015-10-1 15:02 ½s¿è

¦^´_ 1# 7777


    Range("BV" & [BV17] + 1).Formula = [BV2] & [BW1]
¤£¥Î.Select

¥H¤W­±ªºµ{§Ç¨Ó»¡
Range("CJ" & [CJ17] + 1).Select     
ActiveCell.FormulaR1C1 = "=R[-318]C"
ActiveCell.¨ä¹ê´N¬ORange("CJ" & [CJ17] + 1).Select  ªº·N«ä¡A¦ý¦X°_¨Ó«á¡A«o¤£¯à
Range("CJ" & [CJ17] + 1).Select.FormulaR1C1 = "=R[-318]C" ³o¼Ë¼g­n§â.Select§â®³±¼¡A©Ò¥H·|¦p¤U¤@¼Ë
Range("CJ" & [CJ17] + 1).FormulaR1C1 = "=R[-318]C"

TOP

¦^´_ 2# lpk187

·PÁÂ
Formula = ªº¥Îªk
Åý¥»¤H¤Sªø¶i¤F ¤@¨Ç

¤w¸Ñ¨M  3Q
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# 7777


    ¨ä¹ê¡A³o¥y Range("BV" & [BV17] + 1).Select.Formula = [BV2] & [BW1]
¥i¥H²¤Æ¨ì Range("BV" & [BV17] + 1) = [BV2] & [BW1]
.Formula³£¥i¥H¤£¥Î¡A¦]¬°§A³£¬O¥HÀx¦s®æ°µ¬°ÅܼơA¦Ó«á¥u¬O§â­È¦s©ñ¨ìRange("BV" & [BV17] + 1) ¤¤¡A¨Ã¤£¬O¦pExcel¤¤¡A¦p:"=a1+b1ªº¥Îªk©Ò¥H¥i¥H¤£¥Î¥Î¨ì.Formula

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD