ªð¦^¦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 : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD