½Ð°Ý¸Ó¦p¦óÁקK½d³ò¤ºµL¥H¤U±ø¥ó·|¾ÉP¿z¿ï«áªº¸ê®Æ¬°ªÅ¥Õ,±N·|§R°£A2:I5000¤º©Ò¦³¸ê®Æ- Sub ¼Æ¾Ú_§R°£()
- On Error Resume Next
- Sheets("¼Æ¾Ú(¦À\)").Select
- ActiveSheet.Range("$A$1:AA5000").AutoFilter Field:=6, Criteria1:=Array( _
- "¬õ¯ù", "¥¤¯ù", "0"), Operator:=xlFilterValues
- Range("A2:I5000").Select
- Selection.ClearContents
- Selection.AutoFilter
- end sub
½Æ»s¥N½X |