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

5457001E01¡A³o¦b¥ÎVBA¦Û°Ê¤ñ¹ï±ø¥ó¼´¥X­È«áÅܦ¨546E+07¡A³oVBA­n¦p¦ó­×¥¿©O?

±NFÄæ³]¬°[¤å¦r]®æ¦¡, ­«·s¿é¤J5457001E01

TOP

MsgBox [Sheet1!B18] & "   " & [Sheet2!B9]
¨â­Ó¤@¼Ëªº,

¼´¸ê®Æ«e, ­n¥ý±NÀx¦s®æ³]¬°¤å¦r®æ¦¡~~

TOP

¦^´_ 11# jeffrey628litw


    Sheets("¤ñ¹ïOE No«á¸ê®Æ").UsedRange.Clear  'Clear·|¨ÏÀx¦s®æ«ì´_¬°[³q¥Î]®æ¦¡
    Sheets("¤ñ¹ïOE No«á¸ê®Æ").Range("F:F").NumberFormatLocal = "@"  '¥[¤J³o¤@¦æ, ³]¬°[¤å¦r]®æ¦¡
    Sheets("¤ñ¹ïOE No«á¸ê®Æ").[a1].Resize(UBound(Ax, 1), UBound(Ax(1))) = Application.Transpose(Application.Transpose(Ax))

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD