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

¤G­ÓVBAªº°ÝÃD,½ÐÀ°­Ó¦£ ·PÁÂ(¤w¸Ñ¨M)

¤G­ÓVBAªº°ÝÃD,½ÐÀ°­Ó¦£ ·PÁÂ(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ icestormer ©ó 2012-5-3 09:33 ½s¿è


¹Ï¤@:
¦p¹Ï §Ú·Q¨Ï¥Î«ü¥O²M±¼ °Å¶Kï ¤º®e ¦ý¨Ï¥Î«áÓý¨S¤ÏÀ³©O? ¬O«ü¥O¿ù»~?
«ü¥O§Ú¥Îªº¬O:    Application.CutCopyMode = False

¹Ï¤G:
¦p¹Ï §Ú·Q³z¹LVBA ¨Ó¾Þ§@  "¥H¤U¦CÀx¦s®æ¬°°Ñ¼Æ­Èªº¨Ó·½"
¦]¬°§Ú¥Î¥¨¶°¿ý¤£¨ì §ïÅܰѼƭȨӷ½ ªº°Ê§@  
¤£ª¾¥i¤£¥i¥H¨Ï¥ÎVBA»yªk¨Ó¾Þ§@§ïÅÜ¥¦©O?  
½ÐÀ°¦£ ·PÁÂ^^

¦^´_ 1# icestormer


    ²Ä¤@­Ó°ÝÃD:  Application.CutCopyMode = False ¥Îªk¨S¿ù~
            ¦ý¬O°ÝÃD¦b©ó­Y§A·í¤U¬O¨S¦³cut  or cpoy ·íµM´N¨S¦³°ÊÀR
   
    ²Ä¤G­Ó°ÝÃD: ¦³¤@¨Ç¬O¥i¥H³z¹L¿ý»s¥¨¶°ªº¤è¦¡¨Ó¤F¸Ñµ{¦¡½X,¦ý¤£¬O¥þ³¡³£¥i¥H­ò~
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

[quote]¦^´_  icestormer

§Úª¾«Ü¦h¹ï½Í¦¡³£¨Sªk³z¹L¥¨¶°¿ý¨ì°Ê§@±o¨Ï¥Î VBAªº»yªk¤~¦æ

§Ú¬O·Q³z¹Lµ{¦¡½X ¦Û°ÊÅܧó ¹Ï¤G¤¤ªº  °Ñ¼Æ­È¨Ó·½  ¥Ñ ½Æ»s¥Î¬d¸ßªí!$B$8 >>sheet1!$B$8(¨Ò¦p)
³o­Ó¨Sªk¶Ü?

TOP

[quote]¦^´_  icestormer

§Úª¾«Ü¦h¹ï½Í¦¡³£¨Sªk³z¹L¥¨¶°¿ý¨ì°Ê§@±o¨Ï¥Î VBAªº»yªk¤~¦æ

§Ú¬O·Q³z¹Lµ{ ...
icestormer µoªí©ó 2012-3-28 13:50



  ·PÁ ¦³¦^´_ªºªB¤Í  °ÝÃD ¤w¦Û¦æ§ä¨ì¦P®É³B²z¦n¤F ·PÁÂ

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD