- ©«¤l
- 37
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 63
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-8-25
- ³Ì«áµn¿ý
- 2016-5-24
|
¦^´_ 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) |
|