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

[µo°Ý] ¥X²{RUN-TIME ERROR '9': SUBSCRIPT OUT OF RANGE,½Ð°Ý­þ¸Ì¥X²{°ÝÃD¡H

¦^´_ 49# GBKEE

ETA
>=41291

½Ð°Ý§Ú±Nrule ETA Äæset >=41291¡A ¦ý¤U­±ªº¤é´Á³£·|¥X²{¡A¬O¬°¤°»ò¡H

    ETA
18-Dec-11
18-Dec-11
24-Dec-11
25-Feb-12
14-Jan-12
1-Feb-12
11-Feb-12
17-Feb-12
12-Feb-12
20-Feb-13
11-Feb-12
12-Feb-12
7-Mar-12
13-Feb-12
13-Feb-12
25-Feb-12
25-Feb-12
22-Feb-12
20-Mar-12
20-Mar-12
20-Mar-12

TOP

¦^´_ 51# 198188
¤é´Á³£·|¥X²{ : ³o¬OÀx¦s®æªº¤é´Á®æ¦¡
§A¥u»¡ ETA Äæset >=41291  §A»Ý­n¬d¬Ý¾ã­Óµ{¦¡­þ¸Ì¦³³]©w¤F, Àx¦s®æªº¤é´Á®æ¦¡ ¬° .NumberFormatLocal = "[$-C04]d mmmm, yy;@"
§ï¬°  .NumberFormatLocal = "G/³q¥Î®æ¦¡"
³o¨Ç®æ¦¡µ{¦¡½X ¥i¥Î¿ý»s¥¨¶°±o¨ì
PS : $-C04 ­»´ä¦a°Ï ªº®æ¦¡¥N¸¹

TOP

½Ð°Ý³o­Ó­¼¼Æªº¼gªk¹ï¶Ü¡H
Worksheets("Oracle").Cells(i, 19).value Àx¦s­Óªº¸ê®Æ¬O120000
Worksheets("Oracle").Cells(i, 22).Valueªº Àx¦s­Óªº¸ê®Æ¬O30% 7 DAY.
Worksheets(customer).Cells(cnt, 6).Value = Worksheets("Oracle").Cells(i, 19).value * Left((Worksheets("Oracle").Cells(i, 22).Value), 3)

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD