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

¦p¦ó½Æ»ssheet1ªº¤½¦¡µ²ªG¨ìsheet2?

¦p¦ó½Æ»ssheet1ªº¤½¦¡µ²ªG¨ìsheet2?

¥»©«³Ì«á¥Ñ ian1021 ©ó 2012-3-19 18:57 ½s¿è

¦³¤@­Ó°ÝÃD·Q³Â·Ð¤j®a
§Ú²{¦bsheet2¼g¤@­Ó¤½¦¡¥X¨Óªºµ²ªG¦s¨ìG34 (G34=G32+G33)
§Æ±æ«ö¤@­Ó¶s¤§«áª½±µcopy¨ìsheet1ªºF6

ª½±µ»s§@¤@­Ó«ö¶s¥B¼g¬°
Sub Button13_Click()
Sheets("sheet2").[G34].CurrentRegion.Copy Sheets("sheet1").[F6]
End Sub

¦ý¬Oµ²ªG¬Osheet2ªºµ²ªG¬O¿ù»~ªº
¦]¬°¨S¦³¿ìªk±Nsheet2ªº¤½¦¡ (G34=G32+G33)±a¹L¨Ósheet1
½Ð°Ý¦p¦ó¥i¥H±Nsheet2ªº¤½¦¡±a¹L¨Ósheet1  ·PÁÂ!!

¦^´_ 1# ian1021

¿ý»s¤@¤U¡A½Æ»s/¿ï¾Ü©Ê¶K¤W/­È
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


±z¦n  ¤è«KÀ°§Ú¬Ý¤@¤U¶Ü
±ý¹F¦¨  ¦bsheet2 «ö¤U Botton 13«ö¶s´N·|§â[G34]ªºµ²ªG½Æ»s¨ìsheet1ªº[F6]
«D±`·PÁÂ..

Example.rar (23.34 KB)

TOP

¦^´_ 3# ian1021
ª½±µµ¹­È´N¦æ¤F
  1. Sub Button13_Click()
  2. Sheets("sheet1").[F6] = Sheets("sheet2").[G34].Value
  3. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

¨S°ÝÃD¤F!!
«D±`«D±`·PÁª©¤j!!

TOP

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