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

[µo°Ý] µ{¦¡½X..­þ¸Ì¼g¿ù¤F

[µo°Ý] µ{¦¡½X..­þ¸Ì¼g¿ù¤F

½Ð°Ý¦U¦ì¦Ñ®v
¥H¤U³o¬qµ{¦¡½X..­þ¸Ì¼g¿ù¤F
Sheet4.Range("K7:m65536").Copy
Sheets8.Range("A8").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

·P®¦ÁÂÁÂ
·P®¦ÁÂÁÂ
·P®¦ÁÂÁÂ

TOP

¦^´_ 1# oak0723-1


Public Sub fff()

Sheets(8).Range("A8:C65536").Value = Sheets(4).Range("K7:M65536").Value

End Sub

TOP

½T¹ê¦pKubi¦Ñ®v©Ò­z
ÁÂÁÂChangbanana..VBALearner..Kubi¦Ñ®v­Ìªº«ü¾É
§Ú±o¸Ñ¤F

TOP

¦^´_ 1# oak0723-1
³oÀ³¬Oª©¥»°ÝÃD¡A2003ª©·|¥X²{¿ù»~¡A¦]¬°2003ª©³Ì¦h¥u¯à¦s¤J65536¦Cªº¸ê®Æ¡A¦]¦¹§A­n±N65529¦C(¨Ó·½½d³ò)ªº¸ê®Æ©ñ¤J65528¦C(¥Ø¼Ð½d³ò)¬O¤£³Q¤¹³\ªº¡C

TOP

³o¼Ë©O
Sheets(4).Range("K7:M65536").Copy
Sheets(8).Range("A8").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

TOP

VBALearnerÁÂÁ§AÃöª`§Ú³o­Ó°ÝÃD
§Ú¬O¥ý¥Î¿ýªº¦A­×§ï
§Ú¬O·Q§âSheet4.Range("K7:m65536").½Æ»s¨ì
Sheets8.Range("A8")¿ï¾Ü©Ê¶K¤W(­È)
¤£ª¾­þ­Ó¦a¤è¥X¿ù

TOP

¦^´_ 1# oak0723-1

Sheet,Sheets ¤@­Ó¦³s¤@­Ó¨Ss?! ³o¤u§@ªíª«¥ó¦WºÙ¬O§A¦Û¤v³]ªº¶Ü...ÁÙ¬O¥´¿ù?!
²³æªº½Æ»s¶K¤W±Ð¾Ç¦p¤U= ="
https://blog.gtwang.org/programming/excel-vba-programming-workbook-worksheet-cell/3/
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD