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

[µo°Ý] ¦P­ÓÀɮפ£¦P¤u§@ªíªº½Æ»s¶K¤W

[µo°Ý] ¦P­ÓÀɮפ£¦P¤u§@ªíªº½Æ»s¶K¤W

½Ð°Ý¦U¦ì¤j¤j­n«ç»ò±N
¤u§@ªí2ªº¸ê®Æcopy¨ì¤u§@ªí1©O
¦]¬°¤u§@ªí2¦³®É­Ô¬O¤½¦¡
¤u§@ªí1·Q§e²{ªºÀx¦s®æ¤º®e¥u·Q¬°"値"
½Ð°Ý§Ú¼g³o¼Ë­n«ç»ò­×¥¿?
·PÁÂ
  1. Sub DM½Æ»s¶K¤W()
  2. Worksheets("¤u§@ªí1").Range("B2:F7").Value = Worksheets("¤u§@ªí2").Range("B2:F7")
  3. End Sub
½Æ»s¥N½X

¤£¦P¤u§@ªíªº½Æ»s¶K¤W.rar (7.11 KB)

¦^´_ 1# popomilk


    ¹ï¤£°_§Úª¾¹D«ç»ò¼g¤F
§Ú¤£ª¾¹D«ç»ò§R¤å

³Â·Ð¦U¦ì¤j¤j©¿²¤¦¹½g

TOP

¦^´_ 2# popomilk

  ¥i¥H±N¥¿½T¸Ñµª©ñ¤W¨Ó¶Ü¡H
  ·PÁ¡ã
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# 7777


   ³o¼Ë ¬OOKªº...¡AÁÙ¦³ ¨ä¥L¦n¤èªk¶Ü?
    Worksheets("Sheet2").Range("AX132:BF188").Value = Worksheets("Sheet1").Range("AX132:BF188").Value
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD