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

[Âà¶K] VBAªº¼g§@§Þ¥©»P¼W¶i®Ä¯à

¦^´_ 1# Hsieh

¹ï¤F , ¬ðµM·Q¨ì , ¤@¯ë¨Ï¥ÎRangeÅܼÆ
Dim A As Range
Set A = ......

³o¼Ë³Ì«á¤]­n¥ÎSet A= nothingÄÀ©ñ±¼¶Ü?
¦n¹³¤ñ¸û¤Ö¨£

TOP

¦^´_ 1# Hsieh
  ¦n¤å³¹,ÁÂÁ¤À¨É
  ¦n¤å³¹,ÁÂÁ¤À¨É
jeff

TOP

«Ü¨ü¥Î¡A±q¿ý»s¥¨¶°¶}©lºCºC¦b¾Ç²ß¡A¤F¸Ñ¤F«Ü¦h~~

TOP

½d³ò¿ï¾Ü¨ºÃä¯uªº¨ü¯q¨}¦h,¤§«e±`±`¼gvba¼g¹D·í±¼~!
HI~§A¦n§r

TOP

¥»©«³Ì«á¥Ñ jak ©ó 2012-10-22 09:29 ½s¿è

³Ìªñ¶}©l½m²ß¿ý¥¨¶°¡A³Ì±`¬Ý¨ìªº´N¬Oselect:)

TOP

½T¹ê¦³¥Î吔...,¹ïªì¾ÇªÌ¦³¤@©w¼vÅTªº,·P®¦¤F.
tsai

TOP

専¤ß¬Ý¤F¤@¤ù,«Ü¹ê¥Î.

TOP

¦^ÀYÀˬd§ÚÁÙ¯uªº¥Îº¡¦hselect .
ÁÂÁªO¤jªº«ü¾É
Nicole

TOP

·PÁª©¥D¤À¨É
¬Ý§¹¤§«á¨ü¯q¨}¦h

TOP

¦^´_ 1# Hsieh

·PÁ¤j¤jªº«ü¾É
    For Each cell In Range([A1], [A65536].End(xlUp))
¡@......
Next
¤W¦Cªº»yªk¯uªº¨ü¥Î¤£ºÉ

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD