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

½Ð°Ý¦U¦ì¤j¯«¥[§Ö VBA §R°£¬°0ªºÀx¦s®æ¤½¦¡ªºµ{¦¡¼gªk

¥»©«³Ì«á¥Ñ quickfixer ©ó 2019-12-24 05:30 ½s¿è

¦^´_ 1# jeffrey628litw

§AªºÀY§À¦U¥[1¦æApplication.Calculation,´N¥i¥H¶]«Ü§Ö¤F
ABC 20191219-V.04ª©,¨S­×§ï«e,§Úªº¹q¸£­n¶]40¬í
sub tt()
       Application.Calculation = xlCalculationManual

§Aªºµ{¦¡½X

       Application.Calculation = xlCalculationAutomatic
end sub
°õ¦æµ²ªG¦p¤U


¥Î4f,5f§ó§Ö
sub tt()
       Application.Calculation = xlCalculationManual
4f,5fµ{¦¡½X
       Application.Calculation = xlCalculationAutomatic
end sub
°õ¦æµ²ªG¦p¤U
Image 9.png

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD