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

[µo°Ý] ¦p¦ó¨Ï¥ÎVBA±N¤u§@ªí¥t¦s¦¨¥u¦³­Èªº·sÀÉ®×

[µo°Ý] ¦p¦ó¨Ï¥ÎVBA±N¤u§@ªí¥t¦s¦¨¥u¦³­Èªº·sÀÉ®×

½Ð°Ý·í¤@­Ó¬¡­¶Ã¯¤¤¦³¦h­Ó¤u§@ªí¡A
·Q±N¡i¤u§@ªí3¡j¿W¥ß¥X¨Ó¥t¦s¦¨¤@­Ó¬¡­¶Ã¯¡A
¨Ã¥B¤£­n­ì¥»ªº¨ç¼Æ¡A¥u¦s¦¨­Èªº¤è¦¡¡A
VBA­n¦p¦ó¼¶¼g©O¡H

¦^´_ 1# ed3616


Sub TEST()
Sheets("¤u§@ªí3").Copy 'Move
ActiveSheet.UsedRange.Value = ActiveSheet.UsedRange.Value
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 2# Andy2483

·PÁ«e½ú¸Ñµª~
µ{¦¡¤w¶¶§Q¹B¦æ¤F

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD