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

VBAªº®Ä²v°ÝÃD¡J¶V¨Ó¶VºC

VBAªº®Ä²v°ÝÃD¡J¶V¨Ó¶VºC

VBA¶V¶]¶VºC¡A¸Ó«ç¼Ë§ïµ½¡H
¬Ýºô¸ô¤W¦³
Ãö±¼µe­±§ó·s AppLication.ScreenUpdating=False
¥i¬O¦n¹³¨S¦³¤°»ò§@¥Î^^"

¤]¦³«ôŪ¨ìHsieh¶W¯Åª©¥Dªº¤å³¹¤º¦³´£¨ì
Set X = ...¡A«á­±­nSet X = Nothing

½Ð°ÝÁÙ¦³­þ¨ÇÀ³¸Ó­nª`·Nªº¡H
¥ý·PÁ¦U¦ì¤j¤j¤F¡C

¦^´_ 1# papaya

«e´X¤Ñ·Pı³s¶}±Ò EXCEL³£ÅܺC¡A
§â¨t²Î²M²z¤@¤U¡A©~µM®ø°£°Òªº·Pı
²M²z¤u¨ã¬O§K¶Oªº  CCleaner
   
°Ñ¦Ò

TOP

¦^´_ 2# Scott090
S¤j:
·PÁ±z´£¨Ñªº¸ê°T
¤p§Ì¸Õ¸Õ¬Ý²M²zµwºÐ©U§£«á~·|¤£·|´£°ªVBA°õ¦æªº®Ä²v^^

TOP

VBAªº³t«×§ÖºC¡AÀ³¸Ó»PPC®Ä¯à¡A¥H¤Îµ{¦¡½Xªº½s¼g§Þ¥©¦³Ãö¡C
¨Ï¥ÎCCleaner¥u¯à¤Ö¶q¦a§ïµ½¹q¸£®Ä¯à¡A¦ý§Ú·Q¹ï©óVBAªº³t«×§ÖºC¡AÀ°§U¤£¤j¡C

TOP

VBA¶V¶]¶VºC¡A¸Ó«ç¼Ë§ïµ½¡H
¬Ýºô¸ô¤W¦³
Ãö±¼µe­±§ó·s AppLication.ScreenUpdating=False
¥i¬O¦n¹³¨S¦³¤° ...
papaya µoªí©ó 2017-11-11 19:06


¶V¶]¶VºC¬O«ü?
Ãö±¼µe­±§ó·s AppLication.ScreenUpdating=False   << ³o­Ó¤]¥i¥Hµy·L§ïµ½...

¦pªG§A¸ê®ÆÁ`µ§¼Æ¦h¡A§A¤S¨S¥h§PÂ_¨º¨Ç¤w¸g¶]¹L¨º¨Ç¨S¶]  ¦ÓÅýµ{¦¡±qÀY¨ì§À³£¶]¤@¦¸.... ¶V¨Ó¶VºC¬O¥¿±`ªº...
¨Ò¦p ²Ä¤@¤Ñ¸ê®Æµ§¼Æ 60µ§   ²Ä¤G¤Ñ180µ§(60+120) ²Ä¤T¤Ñ 600µ§(180+420) ¥H¦¹Ãþ±À...
³o¼Ë¸g¦~²Ö¤ë ·íµM³B²zªº³t«×·|¶V¨Ó¶VºC...

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 4# JasonChen576
¦^´_ 5# mark15jill

    ÁÂÁ¤G¦ì¤j¤jªº«ü±Ð~·P®¦^^

TOP

¦^´_  JasonChen576
¦^´_  mark15jill

    ÁÂÁ¤G¦ì¤j¤jªº«ü±Ð~·P®¦^^
papaya µoªí©ó 2018-1-31 17:36



    °£«D¡AVBA¬O­nŪ¨ú¥þ½d³ò¸ê®Æ
     ¦pªG¨S¦³¡A¥i¥H¦Ò¼{³]©w½d³ò

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD