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

³Q¤Þ¥Îªºª«¥ó(Àx¦s®æ)³Q§R°£

³Q¤Þ¥Îªºª«¥ó(Àx¦s®æ)³Q§R°£

½Ð°Ý¦U¦ì¤j¤j
¦pªG¦³­Óª«¥óÅܼƤޥΪºÀx¦s®æ³Qdelete¤F,
¨º»ò¸Óª«¥óÅܼƷ|«ü¦V­þ¸Ì©O??

ex:
dim Rng as range
set Rng=[a1]
debug.print Rng.address
[a1].delete
debug.print Rng.address
set Rng=nothing

·í²Ä¤@¦¸debug.print Rng.address®É,ÁÙ·|¨q¥X$a$1,
¥i¬O²Ä2¦¸debug.print Rng.address®É,·|¥X²{"¦¹³B»Ý­nª«¥ó"ªº¿ù»~!!

·PÁ·PÁÂ!
·PÁª©¤jªº¸Ñ»¡!!
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# wealthfree


    ·íÅܼƳQ«ü©w¤º®e«á,´N¤w¸g³QÂê©w
¦¹®É±NÅܼƤº®eª«¥ó§R°£,ÅܼƱNµLªk«ü©w¨ì¥¿½Tª«¥ó¤W(¦]¬°ª«¥ó¤£¦s¦b)
©Ò¥H¥²¶·­«·s³]©wª«¥óÅܼƪºª«¥ó
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ¤j¤j
§Ú¥u¬O¦n©_¸Óª«¥óÅܼƷ|«ü¦V­þ¸Ì??
§Ú¸Õ¹LIs Nothing¤]¤£¬O...
­n¦A¨Ï¥Î¸ÓÅܼÆ,»Ý­n¦Aset¤@¦¸¤~¦æ
·PÁÂ
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

½Ð°Ý¦U¦ì¤j¤j
¦pªG¦³­Óª«¥óÅܼƤޥΪºÀx¦s®æ³Qdelete¤F,
¨º»ò¸Óª«¥óÅܼƷ|«ü¦V­þ¸Ì©O??wealthfree µoªí©ó 2010-6-30 18:33

¨º´N=>  set Rng=nothing

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD