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

½Ð°Ý¦p¦ó³]©w¤@­Ó«ö¶s

½Ð°Ý¦p¦ó³]©w¤@­Ó«ö¶s

§â¹Ï¤ù¤¤¤u§@ªíON Àx¦s®æb6~12ªº­È³]­Ó«ö¶sÅý¥L¶×¤J¨ì¥t¤@­Ó¤u§@ªíAOAªºC3~O3
¤U¦¸¶×¤J®É·|¶×¤J¨ìC4~O4



  1. Private Sub CommandButton1_Click()
  2. AOAend = Sheets("AOA").Columns(3).Find("*", , , , , xlPrevious).Row
  3. Sheets("AOA").Cells(AOAend + 1, "C") = [b6]
  4. Sheets("AOA").Cells(AOAend + 1, "F") = [b7]
  5. Sheets("AOA").Cells(AOAend + 1, "G") = [b8]
  6. Sheets("AOA").Cells(AOAend + 1, "J") = [b9]
  7. Sheets("AOA").Cells(AOAend + 1, "M") = [b10]
  8. Sheets("AOA").Cells(AOAend + 1, "O") = [b12]
  9. End Sub
½Æ»s¥N½X
¦^´_ 1# john711101

TOP

¦^´_ 1# john711101


    §Aªº¸ê®Æ¦³­Ó°ÝÃD,¥»¨­´N¨S¦³¶¶§Ç
¤W­±¤j¤jÀ°§A¼gªºµ{¦¡½X·|¦]¬°±z­ì¥»´N¨S¦³«ö·Ó¶¶§Ç³]­pªí®æ,¦Ó¾É­P¼Æ­È©ñ¿ù¦ì¸m
½Ð¥ý§ó§ï±z¿é¤J¤¶­±ªº¶¶§Ç¸òAOAªº¶¶§Ç¬Û¦P¤§«á¤~¥i¨Ï¥Î
PKKO

TOP

¦^´_ 6# john711101


    ¤£¥ÎPO¹Ï¤ù¤F¡A§Úª¾¹D¬O¤°»ò
¨º¬O¦]¬°§AAOA¤u§@ªíC1:E1¦³³]©w¦X¨ÃÀx¦s®æªºÃö«Y¡A¤@¯ë°µ¬°¸ê®Æ®wªº¤u§@ªí³Ì¦n¤£­n¦³¦X¨ÖÀx¦s®æ¡A¦]¬°¤ñ¸û·|²£¥Í¿ù»~¡A¤£µM¾Ç"ªL¤j"ªºÁôÂæX¨ÖÀx¦s®æ¤]¥i¥H¸Ñ¨M³o°ÝÃD¡I

TOP

ÁÂÁ¦U¦ì¥ý½ú«ü¾É!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD