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

[µo°Ý] ¦p¦ó§Q¥ÎVBA¶i¦æ»y¨¥¤Á´«?

[µo°Ý] ¦p¦ó§Q¥ÎVBA¶i¦æ»y¨¥¤Á´«?

¦U¦ì¤j¤j

sheet3ªíA:B¨âÄ欰ÁcÅé¸ê®Æ°Ï¶ô,
E:F¨âÄ欰«þ¨©A:B¨âÄæ¸ê®Æ«á,
¦A§Q¥ÎExcel¼W¯q¶°,
±NÁcÅ餤¤åÂà¦Ü²Å餤¤å

¦p¦ó§Q¥ÎVBA¶i¦æ»y¨¥¤Á´«?

·Ð½Ð¥ý¶i ¤j¤j«ü¾É
TEST19.rar (12.02 KB)

¦^´_ 1# luke

²Ác¼W¯q¶°
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ¦^ÂÐH¤j

    ²Ác¼W¯q¶°¬O§_¥i¥ÎVBA»yªk¼g¤J¯S©w¦ì¸m
    ¨Ò¦p:
    ¥u¿ï¾Üsheet3ªíE1:F16Àx¦s®æ
    ±NÁcÅ餤¤å§ï¦¨Â²Å餤¤å, ¨ä¾l¤£ÅÜ
   
    ³oºØVBA»yªk¬O§_¥i¥H¼g¥X¨Ó

     ÁÂÁÂ¥ý¶i ¦h¦¸À°¦£

TOP

chijanzen§â¥N½X³£¤À¨É¥X¨Ó¤F¡C
§ï¤@¤UÂà´«ªº½d³ò´N¦æ¤F¡C
Ác².rar (8.67 KB)

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2012-5-10 07:46 ½s¿è

¦^´_ 4# luke
¸Û¦poobirdª©¤j»¡ªº¡A¥L¤w¸g§âµª®×µ¹¤F§A¡A§Ú¦h¨Æ§âoobirdª©¤jªºªþÀɱN¥¦§ï¦¨§A­nªº¡C
§Æ±æ¯à¼W¶i§AªºÁA¸Ñ¡C

§Q¥ÎVBA¶i¦æ»y¨¥¤Á´«Ác²2.rar (19.35 KB)
  1. Sub copyTo()
  2.     ' Range("A1:B16").Copy Destination:=[E1:F16]      ' ¨âºØªí¹F¤è¦¡³£¥i¥H¡A
  3.     [A1:B16].Copy Destination:=[E1:F16]                       ' ®t§O¥u¬O¤¤¦èÀ\¤£¦P¦Ó¤w
  4. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD