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

[µo°Ý] ¦p¦ó¦bÀx¦s®æ¿é¤J¦³Åܼƪº­pºâ¤½¦¡

[µo°Ý] ¦p¦ó¦bÀx¦s®æ¿é¤J¦³Åܼƪº­pºâ¤½¦¡

½Ð敎¦U¦ì¤j¤j§Ú·Q¦b¤U¦CÀx¦s®æ½d³ò ¿é¤J­pºâ¤½¦¡¦]¬°¦C¼Æ·|Åܰʦ]¦¹¼Æ¦r­È (¦C¼Æ)­n§ï¥ÎÅܼÆ

Worksheets(wr).Range(C58:C102).FORMULA="=(B6-$B$3)/$C$3"
Worksheets(wr).Range(D58:D102).FORMULA=(B6-$B$52)/$B$53
§Ú¥Î¤U¦C¤è¦¡¦ý³£¿ù»~,
Worksheets(wr).Range("C" & angin_sr & " C" & xlRow &  ).Formula = "=(B" & angin_sr & "-$B$(angin_sr-3)/$C$(angin_sr-3)"
½Ð敎¦U¦ì¤j¤j­n¦p¦ó¼g¥X¤W­z¥¿½Tªºµ{¦¡

¤£¤Ó©úªº§A·Q­n¦p¦ó¸õ¶Ç,
³æ¬Ý»yªk¤W:
Worksheets(wr).Range("C" & angin_sr & " C" & xlRow).Formula = "=(B" & angin_sr & "-$B$(" & angin_sr - 3 & ")/$C$(" & angin_sr - 3 & ")"

©Î³\¥i¥Hµo¤@¤UÀɤW¨Ó,¬Ý¬Ý·|¤£·|¤ñ¸û©öÀ´
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 2# kimbal
DIM  angin_sr AS  integer

angin_sr  = sr +workshees(wr).ranger("a3").vaiue+6
angin_sr ¬°²Ä¤G¦¸°_©l¦C¼Æ,=  ²Ä¤@¦¸°_©l¦C¼Æ­È(sr)+²Ä¤@¦¸©Ò¦³¦C¼Æ¼Æ¥Ø(workshees(wr).ranger("a3").vaiue)+6®æªÅ®æ

TOP

formula ¸òangin_sr¦³¨Ç¤°»òÃö«Y?
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 4# kimbal
   k¤j:
¹ï¤£°_
Worksheets(wr).Range("C" & angin_sr  ": " C" & xlRow &  ).Formula = "=(B" & angin_sr & "-$B$(angin_sr-3)/$C$(angin_sr-3)"
À³¸Ó¤Ö1 ­Ó   :     ²Å¸¹ §Ú³o»yªk·Q­nªí¹Fªº¬Owr¤u§@ªíÀx¦s®æ"C" ¦C¼Æ   :" C"¦C¼Æ)ªº ½d³ò.formula (³]©w¤½¦¡) =(¬°) ("B"¦C¼Æ  -  "B"¦C¼Æ(Âê©wÀx¦s®æ)  /   "C" ¦C¼Æ( Âê©wÀx¦s®æ)
¦pªG   angin_sr = 58
            xlrow     =   102
«h¤W¦C»yªk·|¬O¤U¦Cªº»yªk
Worksheets(wr).Range("C58" :"C102" ).Formula = "=("B58"-"$B$ 55") /$C$ 55 "

§Ú·Q­n½Ð±Ð«e½úªº¬O¤W¦Cµ{¦¡·í¼Æ¦r¥ÎÅܼƥN´À®É¤W¦C»yªk­n¦p¦ó¼g¥X

TOP

wr = 1
    angin_sr = 58
    xlrow = 102
    Worksheets(wr).Range("C" & angin_sr & " :C" & xlrow).Formula = "=(b" & angin_sr & "-$B$" & angin_sr - 3 & ") /$C$" & angin_sr - 3

TOP

¦^´_ 6# oobird
·PÁÂoobird¤j¤jªºÀ°¦£ °ÝÃD¤w¸Ñ¨M,.¥Î¤F§Aµ{¦¡¤w¯à¥¿½T°õ¦æ

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD