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

[¤À¨É] ¤j½L¨C¤ë¨C¤Ñ¾ú¥v¦¨¥æ¶q»Pª÷ÃB¤U¸ü

¦^´_ 51# usana642
[·í¤é-¦ÛÀç°Ó][·í¤é-§ë«H][·í¤é-¥~¸ê][·í¤é-¦hªÅ²bÃB][¥¼¥­­Ü-¦ÛÀç°Ó][¥¼¥­­Ü-§ë«H][¥¼¥­­Ü-¥~¸ê][¥¼¥­­Ü-¦hªÅ²bÃB]
³o¨ÇÄæ¦ì¬O§ì¨ú  ­pºâ1  ¨º¨Çªº¸ê®Æ??
.Cells(1, 7).Resize(1, 6) = AR µ{¦¡¤¤¨S¬Ý¨ì§ìARªº¸ê®Æ

TOP

¦^´_ 52# GBKEE

GBKEE¤j¤j±z¦n

§Ú¬O·Q§ì¨ú­pºâ1¤u§@ªíªº¤f¼Æ(FÄæ¦ì),ÁÂÁ±z
stock

TOP

¦^´_ 52# GBKEE


    ¤µ¤Ñªº¸ê®Æ¬O¤f¼Æ430,75,-5,317,-4,812,-86,017,870,-13,469,-98,616
ÁÂÁ±z
stock

TOP

¦^´_ 54# usana642
­«ÂI¬O
¬ö¿ý1¤u§@ªí [·í¤é-¦ÛÀç°Ó][·í¤é-§ë«H][·í¤é-¥~¸ê][·í¤é-¦hªÅ²bÃB][¥¼¥­­Ü-¦ÛÀç°Ó][¥¼¥­­Ü-§ë«H][¥¼¥­­Ü-¥~¸ê][¥¼¥­­Ü-¦hªÅ²bÃB] ³o¨ÇÄæ¦ì
§ì¨ú : ­pºâ1¤u§@ªí¤Wªº¨º¨Çªº¸ê®Æ??
  1. Sub Àx¦sOI1()
  2. With Sheets("¬ö¿ý1").Cells(Rows.Count, "A").End(xlUp).Cells(2, 1)
  3. ' *** Sheets("¬ö¿ý1")¤u§@ªíªº A1¶·¥ý¿é¤J¦r¦ê"¤é´Á" ******
  4. ' *** ³o¦æµ{¦¡½X²Ä¤@¦¸°õ¦æ¤~·|¨ì¥¿½Tªº¦ì¸m
  5. 'Cells(Rows.Count, "A").End(xlUp):AÄæ³Ì«á¦C©¹¤W¦³¸ê®ÆªºÀx¦s®æ.Cells(2, 1) :²Ä2¦C ,²Ä1Äæ
  6. .Resize(1, 9) = Array(Date, 2, 3, 4, 5, Sheets("¬ö¿ý1").[F14], [­pºâ1!F14], 8, 9)
  7. 'Date «á­±ªº 2,3,4,5,, ½Ð¦Û¦æ¿é¤J¾A·íªº¦ì¸m
  8. '[­pºâ1!F14] <=> Sheets("¬ö¿ý1").[F14] <=> Sheets("¬ö¿ý1").Range("F14")
  9. End With
  10. End Sub
½Æ»s¥N½X

TOP

¦^´_ 55# GBKEE

GBKEE¤j¤j±z¦n

ÁÂÁ±zªº¼ö¤ß«ü¾É,¤w¸g¥i¥H¥¿±`°õ¦æ¤F,¦A¦¸·PÁ±zªº¼ö¤ß¨ó§U,¯¬±z¨Æ¨Æ¶¶§Q´r§Ö...
stock

TOP

¦^´_ 10# GBKEE


    ½Ð°Ý¦pªGºô­¶¬O²î¤½¥qªº²î´Áªí¡A¥i§_°µ¨ì¡H

TOP

¦^´_ 56# 198188
¨º¤@ºô­¶¥i¤W¶Ç»¡©ú,°Ñ¦Ò¬Ý¬Ý

TOP

¦^´_ 57# GBKEE


    ²î¤½¥qºô­¶.rar (9.32 KB)

½Ð¬Ýªþ¥ó¡A¥Ñ©ó¤Ó¦hºô­¶¡A©Ò¥H¥u¦³´£¨Ñ±¶®|¤_±z¡A¦³³Ò

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-12-3 15:51 ½s¿è

¦^´_ 58# 198188
§Ú¥i¥HÀ°§A°µªº¥u¬O,vba¤Wªº»yªk¤Îµ{¦¡¤Wªº½s¼g,§A¶Ç¤W¤@°ïºô§},§Ú²ö®_¦Ï°Õ.
­«ÂI¬O­n¦³»¡©ú§A·Q°µ¤°»ò

TOP

¦^´_ 59# GBKEE

Desktop.rar (48.91 KB)
¦]¬°»Ý­n¿é¤JÂd¸¹¡AµM«á¤~¥i¥H¥h²î´Áªí¨ºùØ¡AµM«áŪ¨úcurrent ETA?
³o­Ó­n¨D¬O¤£¬O¦³§xÃø¡H

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD