ªð¦^¦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 : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD