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

[µo°Ý] «e¤@¤u§@ªíB1Äæ¦ì­n´_¨î¦b¥Ø«e°Ê§@ªº¤u§@ªíªºA1­n«ç¼gVBA¥i¥HÀ°¶Ü

[µo°Ý] «e¤@¤u§@ªíB1Äæ¦ì­n´_¨î¦b¥Ø«e°Ê§@ªº¤u§@ªíªºA1­n«ç¼gVBA¥i¥HÀ°¶Ü

«e¤@¤u§@ªíB1Äæ¦ì­n´_¨î¦b¥Ø«e°Ê§@ªº¤u§@ªíªºA1­n«ç¼gVBA
¦]¬°«Ü¦h¤@­Ó­Ó´_¨î¤ÓºC

  1. Sub test()
  2. bsh = ActiveSheet.Index - 1
  3. ActiveSheet.[a1] = Sheets(bsh).[b1]
  4. End Sub
½Æ»s¥N½X
¦^´_ 1# xu123

TOP

¦^´_ 2# owen06


    ÁÂÁ¤j¤jÀ°¦£

TOP

¦^´_ 2# owen06


    §Ú¸Õ¹L¤F«Ü¦n¥ÎÁÂÁ§A

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD