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

[µo°Ý] ½Ð°ÝVBA¥i¥H½Æ»sÁôÂ꺤u§@ªíªºÀɮרìµLÁôÂ꺤u§@ªí¤W¶Ü?

[µo°Ý] ½Ð°ÝVBA¥i¥H½Æ»sÁôÂ꺤u§@ªíªºÀɮרìµLÁôÂ꺤u§@ªí¤W¶Ü?




¦p¹Ï:§Ú·Q­n±NSheet2(ÁôÂÃ)¸Ìªº¤º®e½Æ»s¦ÜSheet3¤¤¡A½Ð°ÝVBA­n¦p¦ó¼g?

¦^´_ 1# ´Ñ»y³¾»ï
  1. Sub Ex()
  2.     Sheets("ÁôÂÃ").Cells.Copy Sheets("Sheet3").Cells(1)
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 4# ´Ñ»y³¾»ï
¥Î¥¨¶°¿ý»s¬Ý¬Ý
½m²ß ¿ï¾Ü©Ê¶K¤W--> ¥þ³¡,­È ,®æ¦¡,¤½¦¡ µ¥...
Selection.Copy  §ï¦¨   Sheets("ÁôÂÃ").Cells.Copy
Selection.PasteSpecial  §ï¦¨ Sheets("Sheet3").Cells(1).PasteSpecial

TOP

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