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

[µo°Ý] ¦³Ãö¨Ï¥Î¨Æ¥óµ{§Ç¨ú±o¸ê®Æ(¦³¤G­Ó°ÝÃD)

[µo°Ý] ¦³Ãö¨Ï¥Î¨Æ¥óµ{§Ç¨ú±o¸ê®Æ(¦³¤G­Ó°ÝÃD)

¥»©«³Ì«á¥Ñ icestormer ©ó 2014-1-14 12:33 ½s¿è









¤W¹Ï¬O§Q¥ÎA2ªºª««~¦WºÙ ¥h§ä¨ì¸ê®Æ°Ï¤ºªº½æ»ù¦ý²{¦b¬O¶R»ùªº¤½¦¡¼g¤£¥X¨Ó~~

¤U¹Ï¬O¦UºØª««~¸ê®Æ ¥Ñ©ó¬õ°é³B¸ê®Æµ§¼Æ¤£¦P ©Ò¥H¤£ª¾À³­n«ç¼g¤½¦¡ÅýEXCEL¯à¨ú±o¡@¶R»ùªº»ù¦ì¡]¤wªþ¤WÀɮס^
¦pªG§Ú¦³»¡©ú¤£²Mªº¦a¤è¡A½Ð¨£½Ì¡ã¡ã¡@




Book2.rar (13.75 KB)

¦^´_ 2# stillfish00


  ·P®¦ §Ú¥h¸Õ¸Õ!

TOP

¦^´_ 3# icestormer


    §A¦n µ{§Ç·|«Ü¶¶§Qªº¶]§¹¦ý¥L¤£·|§ó·s©O,SORRY§Ú¨S¦³»¡©ú¥Õ §Ú¬O¥Î¤U¤è«ü¥O³oºØ¨Ó§ó·s

  Selection.QueryTable.Refresh BackgroundQuery:=False

TOP

¥»©«³Ì«á¥Ñ icestormer ©ó 2014-1-15 18:21 ½s¿è

¦^´_ 5# stillfish00


   

¨º­Ó¦n¹³§A»~·|§Úªº·N«ä¤F

§Ú¦A¸ÕªÌ»¡©ú¤@¦¸ ¥D­n¬O¸ê®Æ·|¦³2 ¨ì3¤dµ§ ¦ý¬O¨C¦¸§Ú¤]³\¥u­n§ó·s¨ä¤¤1¨ì3¦Êµ§(¨CºØ¨C¦¸§ó·s®ÉºØÃþ¤£¦P)

§Ú«ö¤U §ó·s»ù¦ì®É ¥L¦n¹³¥u·|§ó·s ¥D¤u§@ªí¤WªºB2¨ìC4(¥Ø«e¤WÀY¥u¦³3µ§¸ê®Æ)¦Ó¤£·|¥h§ó·s ¸ê®Æ°Ï¤ºªº ¦p¤U¹Ï

§Ú·Q¤@­Óµ{¦¡¦b§Ú«ö¤U[§ó·s¥«»ù]®É ¥¦·|¦Û°Ê«ö[¥D¤u§@ªí]¤WA2¨ìAXXX(¬Ý¦³´Xµ§)
¨C¤@µ§¤Wªºª««~¦WºÙ(¨Ò¦p:Pyerite)¥h§ä¨ì¸ê®Æ°Ï¤º¶i¦Ó§ó·s¥¦ ,µM«á¥Ñ©ó¸ê®Æ¶q¤j©Ò¥H¥L¥i¯à·|A¨º©Î¬OH©Î¬O§ó»·ªºAC300¨º¸Ì
¦pªG¥þ³¡¸ê®Æ³£¦b¦P¤@¦æ(A1:A65536)¨º§ÚÁÙ¼gªº¥X¨Ó¦ý¸ê®Æ·|¤À´²¶}©Ò¥H¼g¤£¥X¨Ó><
¦A¦¸·PÁ§Aªº¦^ÂÐ!

TOP

¦^´_ 7# stillfish00


   ¹ï ¨S¿ù ¤£µM§Ú¥u­n¬Ý300µ§¦ý¤@¦¸¥þ³¡§ó·s3¤dµ§...³o..¤Ó¨Sªá®É¶¡¤]¨S¥²­n  ·PÁ §Ú¸Õ¸Õ!^^

TOP

¥»©«³Ì«á¥Ñ icestormer ©ó 2014-1-16 09:53 ½s¿è

¦^´_ 8# icestormer


   

§A¦n §Ú¤@¶}©l ¸Õ³£OK(¦³3µ§) µM«á©O §Úµo²{·í¥u¦³¤@µ§¸ê®Æ®É(¦p¤W¹Ï)´N·|µo¥Í¿ù»~  ¥u­n¦³2µ§¥H¤W¸ê®Æ´N¤£·|¥X¿ù ¤£ª¾­n­×§ï¨º¸Ì©O?


¥t¥~ §Ú§â¨º¤@¦æ¥h±¼ updateprice   ­n¶]®É¦³¿ù»~

TOP

¦^´_ 10# stillfish00


   ·PÁÂ!

TOP

¦^´_  stillfish00


   ·PÁÂ!
icestormer µoªí©ó 2014-1-16 10:29



  ¤w§¹¥þ¨S¦³°ÝÃD..§Ú¦A¦h¸Õ ·PÁªºÀ°¦£^^

TOP

¥»©«³Ì«á¥Ñ icestormer ©ó 2014-1-24 14:19 ½s¿è
¦^´_  icestormer
§ï¤W­±
  With Sheets("¥D¤u§@ªí")
    ar = Application.Transpose(.Range(.Range(" ...
stillfish00 µoªí©ó 2014-1-16 10:18


§A¦n ¥Ñ©óµo²{¥t¤@­Ó°ÝÃD¦ý¤£ª¾«ç¼g ¤S¨Ó½Ð±Ð§A¤F
§Ú·Q¨Ï¥Î¤U­±µ{¦¡½X Åý¥¦¦Û°Ê­«ºâ(§Ú§â¥¦§ï¦¨¤â°Êªº)
'
    Application.MaxChange = 0.001
    ActiveWorkbook.PrecisionAsDisplayed = False
    Calculate
¥Ñ©ó¸ê®Æ¦b§ó·s®É·|¦³2 300µ§ ¤£ª¾À³«ç¼Ë¼g Åýµ{¦¡§P©w ¤w°±¤î§ó·s(¥þ³¡¤w§ó·s§¹¦¨) ¦A°õ¦æ¤W­zµ{¦¡½X©O? ³Â·Ð§A¤F

¥t¥~¤£ª¾¬°¤°»ò¥u­n§ó·s¶W¹L¤Q¦hµ§´N·|¥X¦A²{¦p¤U¹Ïªº±¡ªp,­nµ¥¨ì§ó·s§¹¦¨¤~·|¦^´_¥¿±` ,¦ý³o¥¿±`¶Ü??

TOP

¦^´_ 14# stillfish00


   ¦n ·PÁÂ §Ú¥h¸Õ¸Õ

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD