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

½Ð°Ý¤£¦PÄæ¦ìªº¥[Á`©ñ¦b¸ÓÄæ¦ìªº³Ì«á¤@­ÓÀx¦s®æ,¸Ó¦p¦ó¼g©O~

½Ð°Ý¤£¦PÄæ¦ìªº¥[Á`©ñ¦b¸ÓÄæ¦ìªº³Ì«á¤@­ÓÀx¦s®æ,¸Ó¦p¦ó¼g©O~

¥»©«³Ì«á¥Ñ alltest ©ó 2013-1-15 10:14 ½s¿è

½Ð°Ý¦U¦ì¤j¤j,¤£¦P¤u§@ªí¤£¦PÄæ¦ìªº¥[Á`~
©ñ¦b¸ÓÄæ¦ìªº³Ì«á¤@­ÓÀx¦s®æªºVBA¸Ó¦p¦ó¼g¤~¦n©O?
¦p¹Ï¬õ¦â®Ø®Ø

¦^´_ 1# alltest
ActiveSheet.Range("D" & ActiveSheet.Rows.Count).End(xlUp).Offset(1).FormulaR1C1 = "=SUM(R2C:R[-1]C)"

TOP

ÁÂÁ±z stillfish00¤j¤jªºÀ°¦£^^
¤w¸g°õ¦æ¦¨¥\¤F~·P®¦

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD