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

SET «ü¥O

SET «ü¥O

¥»©«³Ì«á¥Ñ t8899 ©ó 2014-1-5 07:19 ½s¿è

¦³¥Î¹Lset «ü¥O¦bµ{§Ç³Ì«á³£»Ý­n¥[¤W
set ?????= nothing ¶Ü?

¥t¥~¦pªGset «ü¥O¥Î¦bWorksheet_Calculate()
¦³»Ý­n set ?????= nothing ¶Ü?

¦^´_ 1# t8899
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2.     Dim Rng As Range    '³oµ{¦¡¸Ì Dim  ¬°¨p¥ÎÅܼÆ, ¥u¦³³oµ{¦¡¥i¥ÎªºÅܼÆ.¨ä¥Lµ{¦¡¤£¥i¥ÎªºÅܼÆ
  3.     Set Rng = Target
  4.      'µ{¦¡µ²§ô,³oÅܼƷ|³Q¨t²ÎÄÀ©ñ¥X¨Ó,¬O¤£»Ý­n Set Rng = Nothing
½Æ»s¥N½X
  1. Dim Rng As Range   '¼Ò²Õ³»ºÝªº Dim «Å§i¬°³o¼Ò²Õªº¨p¥ÎÅܼÆ,³o¼Ò²Õªº¨ä¥Lµ{§Ç¥i¨Ï¥Î
  2. Private Sub Worksheet_Change(ByVal Target As Range)
  3.         Set Rng = Target
  4.        Set Rng = Nothing  'ÄÀ©ñ: ¦p¨ä¥Lµ{§Ç°õ¦æ¦p¨S¨Ï¥Î¨ì³oÅܼÆ,¥iÂX¤j°O¾ÐÅé
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD