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

·í³v¨B°õ¦æ¥¨¶°®É, ¦p¦ó¼È°±¦Û­q¤½¦¡ªº°õ¦æ

·í³v¨B°õ¦æ¥¨¶°®É, ¦p¦ó¼È°±¦Û­q¤½¦¡ªº°õ¦æ

¥»©«³Ì«á¥Ñ enoch ©ó 2014-11-10 11:46 ½s¿è

·í³v¨B°õ¦æ¥¨¶°®É(F8),
¶¡¤¤´N·|¸õ¦Ü¦Û­q¤½¦¡(Function µ{§Ç),
½Ð°Ý¥i¥H¼È®É°±¤î¦Û­q¤½¦¡ªº°õ¦æ¶Ü?
½Ð¦h¦h«ü±Ð

¦^´_ 1# enoch
  1. Option Explicit
  2. Sub Ex()
  3.    Application.Calculation = xlCalculationManual   'µ{¦¡¶}©l°õ¦æ®É ³]©w¤â°Ê­pºâ
  4.    '
  5.    '
  6.    '
  7.    [A1] = 515        'Àx¦s®æ¦³¼Æ¦rÅÜ°Ê,·|­«·s­pºâ¦Û­q¨ç¼Æ
  8.    [A2] = 5515
  9.    
  10.    'Application.Calculation = xlCalculationAutomatic
  11.    'µ{¦¡µ²§ô«e ³]©w¦Û°Ê­pºâ
  12.    '¦ýÁÙ¬O·|°õ¦æ¦Û­q¨ç¼Æªºµ{¦¡½X
  13. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¨S·Q¨ìÁÙ¦³³oºØ¥\¯à, ¨ü±Ð, ¥u¬O¤£¤F¸Ñ¦ó®É­n¨Ï¥Î³o¥\¯à?¬°¦ó?

TOP

½Ð°Ý
Application.Calculation = xlCalculationManual
»P Application.Calculation = xlManual ¬Û¦P¶Ü?

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-11-11 23:10 ½s¿è
¨S·Q¨ìÁÙ¦³³oºØ¥\¯à, ¨ü±Ð, ¥u¬O¤£¤F¸Ñ¦ó®É­n¨Ï¥Î³o¥\¯à?¬°¦ó?
mmxxxx µoªí©ó 2014-11-10 15:42

¦Û°Ê­pºâ :
¥u­n¤u§@ªí¤º®e¦³ ²§°Ê ©Î¬O ¦sÀÉ »P ÀÉ®×Ãö³¬ «e³£·|°õ¦æ¹Bºâ¤@¦¸.
¤@¯ë«D¯S®í±¡§Î¤j³£·|³]©w¬°¦¹¼Ò¦¡,
¦n³B¬O¥u­n¦³²§°Ê¤£¶·ÃB¥~°Ê§@´N¥i¥H«Ü§Ö¬Ý¨ì¹Bºâµ²ªG,
Ãa³B¬O·í¹J¨ì¤U­z±¡§Î®É¥i¯à¥X²{µL­­°j°é©Î¿ù»~µ²ªG.

¤â°Ê­pºâ:
¥²¶·¬O·í¨Ï¥ÎªÌ«ö¤U¹Bºâ¶s(©Î¬OIJµo¹w³]¹Bºâµ{§Ç)¤~·|°õ¦æ¹Bºâ¤@¦¸.
·í¹Bºâªº°õ¦æ¥i¯à·|©ìºC¥ç©Î¬O©Ôªøµ²ªG²£¥Íªº®É¶¡®É,
©Î¬O¤u§@ªí¤º®e²§°ÊÀWÁcµo¥Í¥ç©Î¬O«e«á¨â¦¸Ä²µo®É¶¡¸ûµu(¦p½L¤¤ªÑ²¼©Î´ÁÅv»ù®æ²§°Ê),
¥i¯à·|µo¥Í«e¦¸¹Bºâ°j°é©|¥¼§¹¦¨´N¤SIJµo¬Û¦P§@¥Îªº¹Bºâ®É.
¤@¯ë·|³]©w¬° ¤â°Ê­pºâ ¼Ò¦¡¥HÁקKµL­­°j°é©Î¬O¿ù»~µ²ªGªº²£¥Í.

½Ð°Ý
Application.Calculation = xlCalculationManual
»P Application.Calculation = xlManual ¬Û¦P¶Ü?
enoch µoªí©ó 2014-11-10 17:13

¥u­n¦b§Y®É¹Bºâµøµ¡¤¤¨D­È´N¥i±oª¾ :
?xlManual
-4135
?xlCalculationManual
-4135

TOP

¦b§Y®É¹Bºâµøµ¡¤¤¸Õ¹L
?xlmanual =-4135
?xlCalculationAutomatic = -4105
·Q½Ð°Ý³o¨Ç¼Æ¦r¦b¥­®É­p³]µ{¦¡©Î°õ¦æ¥¨¶°®É¥i¥HÂIÀ³¥Î©O?

¦³¨S¦³¿ìªk¦b°õ¦æ¥¨¶°®É°±¥Î«ü©wFunction ªº°õ¦æ,
­Y¨Ï¥Î¤â°Ê­pºâ, ¥i¯à¦b°õ¦æ¥¨¶°®É·|¼vÅTµ{¦¡µ²ªG¦Ó¨S¦³¯d·N

½Ð«ü±Ð

TOP

¦^´_ 6# enoch
  1. Calculate ¤èªk ®M¥Î¦Ü½d¨Ò¯S©w­pºâ©Ò¦³¶}±Òªº¬¡­¶Ã¯¡B¬¡­¶Ã¯¤¤ªº¯S©w¤u§@ªí©Î¤u§@ªí¤¤«ü©w½d³òªºÀx¦s®æ¡A¦p¤U²M³æ®æ©Ò¥Ü¡G
  2. ­Y­n­pºâ ¨Ì·Ó¦¹½d¨Ò
  3. ©Ò¦³¶}±Òªº¬¡­¶Ã¯ Application.Calculate (©Î¥u¥Î Calculate)
  4. «ü©w¤u§@ªí Worksheets(1).Calculate
  5. «ü©w½d³ò Worksheets(1).Rows(2).Calculate
½Æ»s¥N½X
  1. Option Explicit
  2. Sub Ex()
  3.     Application.Calculation = xlCalculationManual
  4.     [B1] = 5
  5.     [C1] = 5
  6.     [A1] = "=TEST(B1,C1)"
  7.     [A2] = "=TEST(B1,C1)"
  8.     [B1] = 10
  9.     Range("A1").Calculate  '¥u­«ºâA1,A2¤£·|­«ºâ
  10. End Sub
  11. Function TEST(A, B) As Single
  12.     TEST = A * B
  13. End Function
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD