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

[µo°Ý] ¦p¦ó±NCtrl+C¤¤ªº­È¡A¶K¦bexcel¤W¡H

[µo°Ý] ¦p¦ó±NCtrl+C¤¤ªº­È¡A¶K¦bexcel¤W¡H

¥»©«³Ì«á¥Ñ av8d ©ó 2022-11-22 07:46 ½s¿è

§Ú¦b«DExcelªº¦a¤è(¦p¸ê®Æ§¨¡B°O¨Æ¥»¡Bºô­¶...µ¥)½Æ»s­È( Ctrl+C )
·Q¦bexcel¶K¤W­È
ActiveSheet.Range("A1").PasteSpecial xlPasteValues

·|¥X²{°õ¦æ¿ù»~'1004
Class Range ªº PasteSpecial ¤èªk¥¢±Ñ

11/22 07:46 §ä¨ì¤èªk¤F¡A­×§ï¦p¤U
[A1].Select
ActiveSheet.PasteSpecial xlPasteValues

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD