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

[µo°Ý] §PÂ_¦Û°Ê¿z¿ïAutoFilterªº°ÝÃD

¦^´_ 3# uf023630
  1. Sub Ex()
  2.     With ActiveSheet
  3.         If Not .AutoFilter Is Nothing Then .UsedRange.AutoFilter
  4.     End With
  5. End Sub
½Æ»s¥N½X

TOP

¦^´_ 6# uf023630
AutoFilter ¬Oª«¥ó
ª«¥ó¤£¦s¦b   ª«¥ó Is Nothing   
ª«¥ó¦s¦b      Not ª«¥ó Is Nothing

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD