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

autofilter ¬ÛÃö«ü¥O¤Î¨ç¼Æ

autofilter ¬ÛÃö«ü¥O¤Î¨ç¼Æ

½Ð±Ð­A¦p¦ó°»´ú¬O§_¦³³]©wautofilter, 1.¦pªG¦³, ­n¦p¦ó¨ú®ø;2.¦pªG¨S¦³, ­n¦p¦ó³]©w? ·P®¦!

¦^´_ 1# openpc
ActiveSheet.AutoFilterMode ´N¯à§PÂ_¤F , true´N¬O¦³,false´N¬O¨S¦³
1.  ¨ú®ø
ActiveSheet.AutoFilterMode = False  

2.  ³]©w
ActiveSheet.Range("A1:E5").AutoFilter

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD