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

[µo°Ý] Range.Copy Destination:=Range³ø¿ù

[µo°Ý] Range.Copy Destination:=Range³ø¿ù

½Ð±Ð¦U¦ì¤j¤j¡Acode ¦p¤U¡A°õ¦æ«á¦sÀÉÃö³¬Excel·|³ø¿ù ¡§¹Ï¤ù¤Ó¤j¡A¶W¥Xªº³¡¤À±N³QºI¥h¡C¡¨
¤u§@ªí¤¤¨S¦³¹Ï¤ù¡C½Ð°Ý­þùئ³°ÝÃD¡H

ÁÙ¦³½Ð°Ý¦p¦ó¼gcode¥i¥H¦³®Ä²vªº copy ¤j¶q¸ê®Æ¡A§Ú¥Î Range("B11:BG30010").Value = Sheets("Sheet1").Range("A1:BF30000").Value «ÜºC¡C
µ¥¯Å¦³­­¤£¯à¤W¶Ç¶W¹L1MBªþ¥ó¡A¥u¦n¤À3³¡¤À¡C
data copy - sonny1 - Copy.part1.rar (921.6 KB) data copy - sonny1 - Copy.part2.rar (921.6 KB) data copy - sonny1 - Copy.part3.rar (351.83 KB)
  1. Private Sub Worksheet_Activate()
  2.     Cells.ClearContents
  3.     Sheets("Sheet3").UsedRange.Copy Destination:=Range("B11")
  4. End Sub
½Æ»s¥N½X
sonny-e.gif
ss

¦^´_ 1# sunnyso
§Úªº Excel 2003 ¶]°_¨Ó¤£·|¦³§A»¡ªº¿ù»~­C?
¦³¨S¦³¥i¯à¬Oª©¥»ªº°ÝÃD? -> §A´£¨Ñªºµe­±¬Ý°_¨Ó¤£¤Ó¹³§Ú´¿¸g¨£¹Lªº Excel ªºµe­±, ¤£ª¾¬O­þ­Óª©¥»ªº©O?
¤S©ÎªÌ·|¬O¶}¤Ó¦hµ{¦¡¾É­P°O¾ÐÅ餣°÷¥Î©O? -> ³æ¿W¥u¶] Excel ¬Ý¬Ý¬O§_ÁÙ·|µo¥Í.

TOP

½Ð±Ð¦U¦ì¤j¤j¡Acode ¦p¤U¡A°õ¦æ«á¦sÀÉÃö³¬Excel·|³ø¿ù ¡§¹Ï¤ù¤Ó¤j¡A¶W¥Xªº³¡¤À±N³QºI¥h¡C¡¨
¤u§@ªí¤¤¨S¦³¹Ï ...
sunnyso µoªí©ó 2013-7-24 14:38



    Excel ¤W¦³¼Æ¦Ê­ÓÁôÂùϧÎ, ¸Õ¸Õ¥þ¿ï²M²z¬Ý¬Ý
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 3# kimbal

·PÁ¤j¤j¡A°ÝÃD¤w¸Ñ¨M¡C
ss

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD