ªð¦^¦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 : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD