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

[µo°Ý] [ copy&paste¥\¯à¥¢®Ä ] ¦P®É¥Î¨â­Óexcel

[µo°Ý] [ copy&paste¥\¯à¥¢®Ä ] ¦P®É¥Î¨â­Óexcel

¤@­Óexcel 97 µL­­´Á RUN ¥¨¶°¤¤ ¤§«áÁY¤p¤Æµøµ¡....... (·í¤¤¦³copy&paste¹B§@)

¦P®É¤]¶}¥t¤@­Óexcel 2003 §@·~¤¤...... , °ò¥»¥\¯à³£¥i¥H¥Î¨ì, ¦ýcopy paste ´N¥¢®Ä
´Nºâ¤£¬Oexcel copy paste,  WINDOWS¤¤ ªº copy paste ³£¤@¼Ë¥¢®Ä

½Ð°Ý¦³¨S¦³¿ìªk¸Ñ¨M?

¦^´_ 2# sunnyso
  1. Sub Macro1()
  2. Do
  3. Cells(1, 1).Copy
  4. ActiveSheet.Paste   
  5.   Loop   
  6. End Sub
½Æ»s¥N½X
¨SÀÉ®×, ²³æ¨â¦æ¦r, ´N³o¼Ë¸Õ¸Õ
§Ú¥u¬O·Qª¾¹D¬O¤£¬O¨S¦³¥ô¦ó¿ìªk¸Ñ¨M,
ÁÙ¬O­n¥t¶}¤@­Ó vm window ¥h only for EXCEL ¥h¹B§@¥¨¶°¨º»ò³Â·Ð

TOP

¦^´_ 3# jakcy1234
¶]§A³oµ{¦¡­þ¦³°ò¥»¥\¥i¥Î!
  1. Option Explicit
  2. Sub Macro1()
  3.     Do
  4.         DoEvents
  5.         Cells(1, 1).Copy
  6.         ActiveSheet.Paste
  7.     Loop
  8. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# GBKEE
§Ú¥u¬O·s¤â,¨S¦³°ò¥»¥\,¥u¬O·Q¸Ñ¨M§Úªº°ÝÃD, ¤W¨Ó°Q½×¤À¨É¤@¤U

TOP

¦^´_ 5# jakcy1234

³o¬O¤@­ÓµL½a°j°é¡A¦]¬°§A³oÀɮרSÃö³¬¡A©Ò¥H±N·|¤@ª½¦û¾Ú°Å¶Kï
¬Ý¤£¥X©p³oµ{¦¡¦³¦ó¹ê½è·N¸q
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh

±qµo¤å³¹¶}©l, §Ú´N¨S¦³´£¨Ñ¥ô¦óÀÉ®× ¤]¨S´£¨Ñ»y¥y, ¥u¬O«Ü²²³æ³æ¸Ñ»¡µo°Ý¤@¤U:
"""""" ¦brun ¥¨¶°¶i¦æ®É, ¤£¯à¦bwindowµøµ¡¤¤¶i¦æcopypaste...."""""""
§Ú¤]¨S¥ô¦ó¨è·N¥h³]­p¤@­Óµ{¦¡¥hª±§Ë, §A¤]¤£¥²­n°õµÛ¦³¤°»ò·N¸q

§Ú¤£¬O¹q¸£µ{¦¡­û, ¤]¤£¬O¼gvb°ª¤â
§Ú¥u¬O·QÃD°Ý¤@¤U....§Ú¦³¥¨¶°­n¤@ª½ªø¤[run¤U¥h¦¬¶°¼Æ¾Ú°µbacktest, ¦Ó·í¤¤¦³copy&paste¹B¦æ¤¤,
³æ³æ¾a target,source,find,cells,range ¤£¥Îcopy paste ¤Þ¤Jformula³£¥i¥H°µ¨ì, ¦ý³t«×¤ÓºC.

Google search ¤@¤U¤]«Ü¦htopic Ãö©ó " VBA Copy Paste interferes "

ºô¤W§Ú¤]§ä¨ì¿ìªk , ¦ý¬O¤£·Q§ï³o­Ó°µªk, ¤£ª¾¹D§A¦³¨S¦³§ó¦nªº°µªk. ÁÙ¬O¥u¦n¶}VM ¥hrun¸Ñ¨M³o­Ó°ÝÃD.
CopyRangeWithoutClipBoard(Source As Range, Target As Range)

TOP

¦^´_ 7# jakcy1234
¦brun ¥¨¶°¶i¦æ®É, ¤£¯à¦bwindowµøµ¡¤¤¶i¦æcopypaste....,¸ê·½³£³Q§A¦û¾Ú,·íµM¤£¯à¦bwindowµøµ¡¤¤¶i¦æcopypaste

§A¥u¬O·QÃD°Ý¤@¤U....§Ú¦³¥¨¶°­n¤@ª½ªø¤[run¤U¥h¦¬¶°¼Æ¾Ú°µbacktest, ¦Ó·í¤¤¦³copy&paste¹B¦æ¤¤,
³æ³æ¾a target,source,find,cells,range ¤£¥Îcopy paste ¤Þ¤Jformula³£¥i¥H°µ¨ì, ¦ý³t«×¤ÓºC.
³t«×­n§Ö¤@¨Ç,¤]­n¬Ý¬Ý§Aªºµ{¦¡½X¦p¦ó¸É±Ï!
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD