- ©«¤l
- 134
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- EXCEL 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¶³ªL
- µù¥U®É¶¡
- 2010-10-6
- ³Ì«áµn¿ý
- 2018-5-13
|
·PÁÂHsieh ª©¥D¡A¦]¤p§Ììq³æ¸ê®Æ¤¤°£¤FG¤ÎJÄæ¦ì¦³¤½¦¡¥~¡A©|¦³¤½¦¡ªºÄæ¦ìÁÙ¦³N,P,R,S,WÄæ¦ì¡]Äæ¦ì¶¶§Ç¼Æ¬°14,16,18,19,23¡^¡A¤p§Ì¨Ì¼Ëµe¸¬Äª³]©w¤½¦¡¦p¤U¡A«oµLªk©µ¦ù®M¨ú¤½¦¡¡A½Ð°Ý¨º¸Ì¦³¿ù©O????
Ar = Array(A.Offset(, -10).Value, IIf(A.Offset(, -12) = "IS" Or A.Offset(, -12) = "IN", 2, ""), Date, A.Offset(, -7).Value, A.Offset(, -3).Value, A.Offset(, -11).Value, B.Offset(-1, 6).FormulaR1C1, A.Offset(, -9).Value, A.Offset(, -8).Value, B.Offset(-1, 9).FormulaR1C1, A.Offset(, -5).Value, , , B.Offset(-1, 13).FormulaR1C1, , B.Offset(-1, 15).FormulaR1C1, , B.Offset(-1, 17).FormulaR1C1, B.Offset(-1, 18).FormulaR1C1, , , , B.Offset(-1, 22).FormulaR1C1) |
|