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

·s¤â´£°Ý~RANGEÅܼƪí¥Ü

·s¤â´£°Ý~RANGEÅܼƪí¥Ü

¦U¦ì¤j¤j¦n~
§Ú¬OVBA·s¤â³Ìªñ¦b»s§@ªí®æ
¦ý¬O¦³²~ÀV~§Ú·Q¥ÎRANGE¥ÎÅܼƪí¥Ü
¤£ª¾¦p¦ó
CELLS¦n¹³µLªk¥Î½d³ò~  

§Ú¼g¤U­±¤£ª¾­þ¿ù
Worksheets("¤é³ø").Range("D5:D28").Value = Worksheets("¼Æ¶q").Range(Cells(6, 7+i), Cells(29, 7+i)).Value

¦^´_ 1# dlwow

Worksheets("¤é³ø").Range("D5:D28") = Worksheets("¼Æ¶q").Range(Worksheets("¼Æ¶q").Cells(6, 7 + i), Worksheets("¼Æ¶q").Cells(29, 7 + i)).Value

TOP

¦^´_ 2# owen06


¬OI«ü©w¤@­Ó­È½d³ò~ÁÂÁ§A¦^Âе¹§Ú:)

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD