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

½Ð¦U¦ì¥ý¶i¤Î¤j¤jÀ°¦£§Ú§Ö¥¢¥h°Ê¤O¤F

¦^´_ 1# farmer900

L3=MID(RIGHT(J3,12),9,2)

TOP

¦^´_ 3# farmer900

J3³]©w¬°¤å¦r®æ¦¡
¦A¶]1¦¸µ{¦¡

TOP

¦^´_ 5# farmer900
  1. Sub AA()
  2. Range("L3") = Mid(Right(Range("J3"), 12), 9, 2)
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 7# farmer900

J3³]©w¬°¤å¦r®æ¦¡
  1. Sub AA()
  2. Range("L3") = Mid(Right(Range("J3"), 12), 9, 2)
  3. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD