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

[¤À¨É] ²¬Ù®É¶¡ vba¤j¶q¶]µ{¦¡ªº¤p¯µ³Z

[¤À¨É] ²¬Ù®É¶¡ vba¤j¶q¶]µ{¦¡ªº¤p¯µ³Z

  1. Cells.Select
  2.     Selection.Copy
  3.     Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
  4.         :=False, Transpose:=False
½Æ»s¥N½X
¦]¬°§Ú¤§«e¤j¶q¶]µ{¦¡  ¤@¶]´N¬O1¤p®É  ·Q»¡§âµ{¦¡¥u¯d  ¼Æ¾Ú  ¤£¯dºâ¦¡ªº°µªk
¦bµ{¦¡«áÀY   ¥[¤J¤W¦Cµ{¦¡  ¬ðµM­¸§Öªº5¤ÀÄÁ¶]§¹  
­«ÂI¦b©ó ³o©Û¯à¨Ï°O¾ÐÅé¨Ï¥Î²v¤£·|¤j¼W  µ{¦¡¦ÛµM¶]±o§Ö
²M°ª ¯Ü®zªº°°¹¢

¦p¦P ½Æ»s  ¥kÁä ¿ï¾Ü©Ê¶K¤W  ¡÷­È   (¨Ï¥Î¿ý»s)
¹ï©óªì¾Ç¨Ó»¡¬O«Ü¦n¥Îªº»yªk µ¹§A­ÓÆg!

TOP

³o¤èªk¤£¿ù,§Ú¤£¤Ó·|¥Îvba©Ò¥H¨ç¼Æ¦h®É¤]¥Î³oÁ`¤è¦¡
kuoliang

TOP

¼ÐÃD­Ë«Ü§l¤Þ¤H¡A¥i±¤µL¬Û¹ï¤º®e
³o­Óµ{¦¡½X¥Î¦b¨S¦³¤½¦¡ªº¤u§@ªí¤W§¹¥þ®ö¶O®É¶¡

TOP

¼ÐÃD­Ë«Ü§l¤Þ¤H¡A¥i±¤µL¬Û¹ï¤º®e
³o­Óµ{¦¡½X¥Î¦b¨S¦³¤½¦¡ªº¤u§@ªí¤W§¹¥þ®ö¶O®É¶¡
chin15 µoªí©ó 2012-11-24 21:11


¦pªG­n¥Î¦b¨S¦³¤½¦¡ªº¤u§@ªí
¥i¯à­n¥ÎÄÀ©ñ°O¾ÐÅ骺³nÅ黲§U  ·|¤ñ¸û¦n
§Ú±ÀÂËCleanMem 2.4.3  §Ú¤@ª½³£¦³¨Ï¥Î

©ÎªÌÁÙ¦³­þ¦ì¯«¤H  ¯à¦A´£©Þ§Ú­Ì³o·Q°l¨D¤u§@¶i«×ªº¤Hªü
²M°ª ¯Ü®zªº°°¹¢

TOP

§Ú±`±`³o¼Ë¼g,¦P¼Ë¥i¥H
set R=activesheet.usedrange
R.value=R.value
lmh

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD